Thread Tools Display Modes
  #1   Report Post  
aplarsen aplarsen is offline
Junior Member
Posts: 1
Default Drawing a circle or box with merge data

At my school, we merge in a bunch of data to create a snapshot of each student for scheduling purposes. We call it the scheduling rubric.

An example is attached below:

Uploaded with

Each student receives a score on the tests or GPA, and their scores are listed in blue down the left side. The cutscores are listed in a matrix in the middle of the sheet, and the appropriate number of points (1-9) is dropped into the columns on the right. All of the math is done in Excel beforehand. Word is just used to dress it up and create a digestible format for parents.

I'd like to figure out a way to circle the or otherwise identify cutscore that corresponds to the point value that they are receiving on the right side. Otherwise, the 1-9 value appears to come out of thin air. The closest I have come to an idea is to create fields in Excel that are converted into a Wingdings check mark in the appropriate cell. Any other thoughts?
  #2   Report Post  
Big_Al Big_Al is offline
Junior Member
Location: Bristol UK
Posts: 22

The only thing I can think of would be to shove some conditional formatting into the score 1-9 array (this is in the excel template generating the report).

Perhaps either bolding or colouring the text/borders if the value of the 1-9 score is less than or equal to the score. Or the other way round to show what they didn't achieve.

Personally, I'd replicate the nice blue font, in the cells the student achieved

Not elegant by any means, but without some coding help, I think this is the only way.
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Drawing a circle around a portion of print screen in a Word docume Eden397 Microsoft Word Help 4 May 5th 23 08:49 PM
Hide text box Lily Yu Microsoft Word Help 0 December 25th 10 02:36 AM
Create Select All Check Box lajohn1963 Tables 0 September 21st 10 08:45 PM
Layout Formatting in a Text Box RTElectric Page Layout 0 July 9th 10 05:05 PM
Drawing a Half-Circle and Half-Ellipse (Word 2003)? W. Watson New Users 3 January 27th 06 03:18 PM

All times are GMT +1. The time now is 03:40 PM.

Copyright ©2000 - 2023, Jelsoft Enterprises Ltd.
Copyright 2004-2023 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.

About Us

"It's about Microsoft Word"