Microsoft Office Tutorials and References
In Depth Information
New Conditional Formatting Features
You may choose:
1. Top 10 Items
2. Top 10%
3. Bottom 10 Items
4. Bottom 10%
5. Above Average
6. Below Average
See Figure 5.4.
These basic rules may be further modified later for comparable conditions. For
example, use the top 10 percent and modify it to be the top 15 percent or top 15
items. I used the Top 10 Items rule of the sheet named Top Bottom Rules on the
Chapter 5 workbook. See the results in Figure 5.5.
FIGURE 5.4 Top/Bottom Conditional Formatting Rules
FIGURE 5.5 Top 10 Items in the Range Are Formatted with a Gray Background
Search JabSto ::




Custom Search