Excel 2010 Bible

Chapter 20: Visualizing Data Using Conditional Formatting

499

FIGURE 20.18

The sum is displayed only when all four values have been entered.

FIGURE 20.19

A missing value causes the sum to be hidden.

Working with Conditional Formats

This section describes some additional information about conditional formatting that you may

find useful.

Managing rules

The Conditional Formatting Rules Manager dialog box is useful for checking, editing, deleting, and

adding conditional formats. First select any cell in the range that contains conditional formatting.

Then choose Home ➪ Styles ➪ Conditional Formatting ➪ Manage Rules.

You can specify as many rules as you like by clicking the New Rule button. As you can see in

Figure 20.20, cells can even use data bars, color scales, and icon sets all at the same time —

although I can’t think of a good reason to do so.