Microsoft Office Tutorials and References
In Depth Information
Figure 19-22: 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
To copy only the formatting (including conditional formatting), copy the cells and then
use the Paste Special dialog box and select the Formats option. Or, use Home ⇒ Clip-
board ⇒ Paste ⇒ Formatting (R).
If you insert rows or columns within a range that contains conditional formatting, the new cells have the same
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.
Locating cells that contain conditional formatting