Microsoft Office Tutorials and References
In Depth Information
Managing conditional formatting rules
Figure 9-29 Click the Collapse button in the Applies To text box to minimize the dialog box and
allow direct selection of the cell range you want.
When two (or more) conditional rules are true for a particular cell but they are both set
to apply a similar format, such as font color, the rule that is higher in the Conditional
Formatting Rules Manager dialog box’s list of precedence wins. Try to make multiple
conditions compatible by having each rule apply a different type of format, such as the
first rule applying cell color, the second applying font color, and the third applying bold
formatting. In addition, conditional formats override manual formats when the
condition in the cell is true.
Copying, clearing, and finding conditional formats
You can copy and paste conditionally formatted cells and use the Fill features or the Format
Painter button to copy cells you have conditionally formatted. When you do, the
conditional rules travel with the copied cells, and a new rule is created that references the new
location in the workbook.
To remove conditional formatting rules, click Home, Conditional Formatting, Clear Rules,
and then click Clear Rules From Selected Cells or Clear Rules From Entire Sheet to clear all
the corresponding rules. If your conditions have been applied to a table or a PivotTable,
additional corresponding commands are available.