Microsoft Office Tutorials and References
In Depth Information
Figure 5–84. Color scheme: Selecting a cell formatting color
10. You’ll be brought back to the Greater Than dialog box. Click OK.
11. Turn off the blue selection color
surrounding the test score range
D6:D15. You’ll see the content
shown in Figure 5–85.
Figure 5–85. Well done, Quincy!
To summarize, we used the conditional formatting feature to highlight all the cells that
meet a condition we specified—in this case, all test scores over 90. We selected the
cells we wanted to analyze, clicked the appropriate conditional formatting option (in this
case the Greater Than… option), entered our greater-than-90 criterion, and then chose the
color we wanted to apply to the cells that met the condition. And we see that only
Quincy surpassed the 90 mark.