Microsoft Office Tutorials and References
In Depth Information
Copying cells that contain conditional formatting
You can specify as many rules as you like by clicking the New Rule button. As you can see in
Figure 19.26, cells can even use data bars, color scales, and icon sets all at the same time — if
you can think of a good reason to apply all those types of formatting to one set of data.
FIGURE 19.26
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.
19
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 choose Home ➪ Clipboard ➪ Paste ➪ Formatting (R).
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 don’t delete the conditional
formatting for the cell (if any). To remove all conditional formats (as well as all other cell
formatting), select the cell and then choose Home
Clear Formats. Or
choose Home Editing Clear Clear All to delete the cell contents and the conditional
formatting.
Editing
Clear
Search JabSto ::




Custom Search