Microsoft Office Tutorials and References
In Depth Information
Chapter 4: Chartless Visualization Techniques
The benefit of a conditional formatting rule is that Excel automatically reevaluates the rule each time
a cell is changed (provided that cell has a conditional formatting rule applied to it). For instance, if
you were to change any of the low values to 450, the formatting would automatically change
because all of the cells in the dataset have the formatting applied to it.
Applying Top/Bottom Rules
The formatting options in the Top/Bottom Rules category, shown in Figure 4-5, allow you to
highlight those cells whose values meet a given threshold.
Figure 4-5: The Top/Bottom Rules options apply formats if specific thresholds are met.
As with the Highlight Cells Rules, these options work like If…Then…Else… statements:
➤ If the condition is met, the cell is formatted.
➤ If the condition isn’t met, the cell isn’t touched.
In the Top/Bottom Options category, you can select a percentage or number of cells.
Some of the names of the options are misleading. Options that are named with 10 Items
can select any number of cells, and options that are named with 10% can select any
You can select from these options:
➤ Top 10 Items: Allows you to specify any number of cells to highlight based on individual cell
values (not just 10 cells).
For example, you can highlight the cells whose values are the 5 largest numbers of all the
➤ Top 10%: Allows you to specify any percentage of cells to highlight based on individual cell
values (not just 10 percent) option.