Microsoft Office Tutorials and References
In Depth Information
There may be times when you want to call special attention to certain cells. For
example, you may be working with a list of test scores and want to quickly be able to tell
which tests exceed a certain score, fall below that score, or both. Excel’s conditional
formatting feature lets you format cells so that they change their appearance only when
they meet conditions you specify.
To continue with our example, with conditional formatting you can instruct any cell with
a value greater than, say, 90 (a high test score) to turn blue—but only if it tops 90.
Otherwise, the cell will continue to exhibit its original appearance. Thus, conditional
formatting is an effective, and pretty easy, way to highlight certain cells scattered among
a large mass of data (imagine reviewing 5,000 test scores!).
In fact, Excel gives the user many different ways to engineer conditional formats, some
more complex than others. But many can be quite simple, even almost self-evident.
Let’s demonstrate one now, by turning to our test example.
1. Start by entering the test
results from Figure 5–80 in
Figure 5–80. Testing, testing . . . looking for scores
NOTE: Remember our objective: we want to be able to quickly identify all those scores that have
achieved 90 or higher by having their cells turn blue.
2. Select the range of scores we want to conditionally format: D5:D15.
3. Click the Conditional Formatting button in the Styles button group on the
Home tab (see Figure 5–81).