Excel 2010 Bible

Part III: Creating Charts and Graphics

500

FIGURE 20.20

This range uses data bars, color scales, and icon sets.

Copying cells that contain conditional formatting

Conditional formatting information is stored with a cell much like standard formatting information

is stored with a cell. As a result, when you copy a cell that contains conditional formatting, you

also copy the conditional formatting.

Tip
To copy only the formatting (including conditional formatting), use the Paste Special dialog box and select the
Formats option. Or, use Home ➪ Clipboard ➪ Paste ➪ Formatting (R). n

If you insert rows or columns within a range that contains conditional formatting, the new cells

have the same conditional formatting.

Deleting conditional formatting

When you press Delete to delete the contents of a cell, you do not delete the conditional formatting

for the cell (if any). To remove all conditional formats (as well as all other cell formatting), select

the cell. Then choose Home ➪ Editing ➪ Clear ➪ Clear Formats. Or, choose Home ➪ Editing ➪

Clear ➪ Clear All to delete the cell contents and the conditional formatting.

To remove only conditional formatting (and leave the other formatting intact), use Home ➪

Styles ➪ Conditional Formatting ➪ Clear Rules.