Microsoft Office Tutorials and References
In Depth Information
Formatting—With Conditions
Figure 4–119. Icon Set options
Directional Icon Sets symbolize values by their position in a percentile scale via the designated
icons. Thus if I select the first such option and apply it to the grade range, the conditional format looks
like this (Figure 4–120):
Figure 4–120. An arrow icon set in action
Here we see that the highest scores sport an up arrow, the intermediates a flat one, and the lower
scores a down arrow.
Shapes represent values with a trove of shapes. If I apply the second selection in the Shapes first
column on the grade range, I’ll see this (Figure 4–121):
Search JabSto ::

Custom Search