Microsoft Office Tutorials and References
In Depth Information
Chapter 4: Chartless Visualization Techniques
For instance, you can highlight the cells whose values make up the top 20 percent of the
total values of all the selected cells.
Bottom 10 Items: Allows you to specify the number of cells to highlight based on the lowest
individual cell values (not just 10 cells).
For example, you can highlight the cells whose values are within the 15 smallest numbers
among all the cells selected.
Bottom 10%: Allows you to specify any percentage of cells to highlight based on individual
cell values (not just 10 percent).
For instance, you can highlight the cells whose values make up the bottom 15 percent of the
total values of all the selected cells.
Above Average: Allows you to conditionally format each cell whose value is above the
average of all cells selected.
Below Average: Allows you to conditionally format each cell whose value is below the
average of all cells selected.
In this example, you conditionally format all cells whose values are within the top 40 percent of the
total values of all cells.
To avoid overlapping different conditional formatting options, before applying a new
option, you may want to delete any conditional formatting you’ve previously applied.
To clear the conditional formatting for a given range of cells, select the cells, go to
Ribbon, and select Home Conditional Formatting. Here you find the Clear Rules
tion. Click Clear Rules and select whether you want to clear conditional formatting for
the entire sheet or only the selected workbook.
Note
1. Select the range of cells to which you need to apply the conditional formatting.
2. In the Top/Bottom Options category, choose Top 10% (see Figure 4-5).
The Top 10% dialog box opens, as illustrated in Figure 4-6. Here you define the threshold
that that will trigger the conditional formatting.
3. In this example, enter .
Here you can also use the drop-down menu to specify the format you want to apply.
Figure 4-6: Each option has its own dialog box where you can define its trigger values and format.
Search JabSto ::




Custom Search