Page 465 - Excel 2007 Bible

27_044039 ch21.qxp 11/21/06 11:12 AM Page 422
Part III
Creating Charts and Graphics
n Words that contain X: If the cell contains X (upper or lower case), the cell is highlighted.
n Data bars: Each cell displays a horizontal bar, proportional to its value.
n 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.
n Icon Set: One of many icon sets. It displays a small graphic in the cell. The graphic varies,
depending on the cell value.
n Icon Set: Another icon set.
n Custom rule: The rule for this checkerboard pattern is based on a formula:
=MOD(ROW(),2)=MOD(COLUMN(),2)
FIGURE 21.1
This worksheet demonstrates a few conditional formatting rules.

Specifying Conditional Formatting

To apply a conditional formatting rule to a cell or range, select the cells and then use one of the commands
on the Home ➪ Styles ➪ Conditional Formatting drop-down to specify a rule. The choices are
n Highlight Cell Rules: Examples rules include highlighting cells that are greater than a particular
value, between two values, contain specific text string, or are duplicated.

422