Part III: Creating Charts and Graphics
482
l (^) Duplicate values: Values that appear more than one time are highlighted.
l Words that contain X: If the cell contains X (upper- or lowercase), the cell is highlighted.
l (^) Data bars: Each cell displays a horizontal bar, proportional to its value.
l Color Scale: The background color varies, depending on the value of the cells. You can
choose from several different color scales or create your own.
l Icon Set: One of several icon sets. It displays a small graphic in the cell. The graphic var-
ies, depending on the cell value.
l Icon Set: Another icon set, with all but one icon hidden.
l (^) Custom rule: The rule for this checkerboard pattern is based on a formula:
=MOD(ROW(),2)=MOD(COLUMN(),2)
On the CD
This workbook, named conditional formatting examples.xlsx, is available on the companion
CD-ROM. n
FIGURE 20.1
This worksheet demonstrates a few conditional formatting rules.