Microsoft Office Tutorials and References
In Depth Information
Chapter 4: Chartless Visualization Techniques
Excel provides a clever mechanism to allow you to stop evaluating and formatting values if a
condition is true.
In this example, you remove the Check icons. The cells that contain those icons all have values above
the average for the range. Therefore, you first need to add a condition for all cells whose values are
1. Select the target range of cells; then click the Home tab and select Conditional
Formatting ➜ Manage Rules.
The Conditional Formatting Rules Manager dialog box opens, as shown in Figure 4-19.
2. Click the New Rule button to start a new rule.
Figure 4-19: Open the Conditional Formatting Rules Manager and select New Rule.
3. Click the rule type Format Only Cells That Contain. Then configure the rule so that the format
applies to cell values greater than the average (see Figure 4-20).
4. Click OK without changing any of the formatting options.
Figure 4-20: This new rule applies to any cell value that you don’t want formatted.