Microsoft Office Tutorials and References
In Depth Information
Formatting—With Conditions
Figure 4–117. Chromatic scales: Color Scales options
By selecting the second option on the first row—called the Red-Yellow-Green Color Scale , an d
applying it to our range of grades, I get this (Figure 4–118):
Figure 4–118. Grade values, colored by score group
In this color scheme, Red captures the highest values, Yellow the intermediate ones, and Green the
lowest—all in shadings to reflect fine differences in values.
The final option— Icon Sets —supplies the user with a large assortment of symbols with which to
format the relationship between values, and in a range of ways (Figure 4–119):
Search JabSto ::

Custom Search