Microsoft Office Tutorials and References
In Depth Information
New Conditional Formatting Features
To change the rule and format, for example, the top 15 percent follow three
1. Click on Conditional Formatting and choose Manage Rules.
2. Select Edit Rule.
3. Change the Top 10 to be Top 15.
See Figure 5.6.
Now the range has the top 15 items formatted. See Figure 5.7.
FIGURE 5.6 Modify Top 10 Rules to Top 15 Conditional Format
FIGURE 5.7 Top 16 Items in the Range Are Formatted with a Gray Background