Microsoft Office Tutorials and References
In Depth Information
Chapter 19: Conditional Formatting and Data Validation
Figure 19-15: 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 how 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.
To copy only the formatting (including conditional formatting), use the Paste Special
dialog box and select the Formats option. Or, choose Home➜Clipboard➜Paste➜Other
Inserting rows or columns within a range that contains conditional formatting causes the new
cells to 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 cells and choose Home
Clear Formats. Or, choose Home
Clear All to delete the cell contents and the conditional formatting.
To remove only conditional formatting (and leave the other formatting intact), choose
Find and replace limitations
Excel’s Find and Replace dialog box includes a feature that allows you to search your worksheet
to locate cells that contain specific formatting. This feature does not locate cells that contain
formatting resulting from conditional formatting.