Excel 2010 Bible

Part III: Creating Charts and Graphics

490

FIGURE 20.9

This worksheet, which uses color scale conditional formatting, displays an impressive color gradient.

Note
You can’t hide the cell contents when using a color scale rule, so I formatted the cells using this custom num-
ber format (which effectively hides the cell content):

;;;

Using icon sets

Yet another conditional formatting option is to display an icon in the cell. The icon displayed

depends on the value of the cell.

To assign an icon set to a range, select the cells and choose Home ➪ Styles ➪ Conditional

Formatting ➪ Icon Sets. Excel provides 20 icon sets to choose from. The number of icons in the

sets ranges from three to five. You cannot supply your own icons.