Excel 2010 Bible

Part III: Creating Charts and Graphics

494

FIGURE 20.14

Hiding one of the icons makes the table less cluttered.

Creating Formula-Based Rules

Excel’s conditional formatting feature is versatile, but sometimes it’s just not quite versatile enough.

Fortunately, you can extend its versatility by writing conditional formatting formulas.

The examples later in this section describe how to create conditional formatting formulas for the

following:

l To identify text entries

l (^) To identify dates that fall on a weekend
l To format cells that are in odd-numbered rows or columns (for dynamic alternate row or
columns shading)
l To format groups of rows (for example, shade every two groups of rows)
l (^) To display a sum only when all precedent cells contain values
Some of these formulas may be useful to you. If not, they may inspire you to create other condi-
tional formatting formulas.