You can apply more than one conditional formatting rule to a column.
For example, for a column of test scores, you can apply one rule that formats
cells that contain passing scores as green. You can then apply another rule to
the same column that formats cells that contain failing scores as red. When you
apply multiple formatting rules, you can manage those rules in the
Manage Rules
dialog box.
Change the order of precedence for rules
If you enter more than one rule for a column, then the last rule you entered has precedence over the next to the last rule, and so on. However, you can change the order of precedence of the rules.
- Choose .
-
From
Show formatting rules for,
select the column.
The conditional formatting rules for the selected column are displayed under Rules in their order of precedence.
- Select a rule and use the up and down arrow buttons to change its place in the order of precedence.
- To return to the original order, click Reset.
-
To delete a rule, select it, then click the
Delete button
.
- Click OK.
Delete conditional formatting rules
To delete all rules for a column, click in the column, then right-click and choose .
To delete all rules for a worksheet, click in the worksheet, then right-click and choose .
To delete selected rules for a column, do the following:
- Click in the column, then right-click and choose .
- From
Rules,
select the rule that you want to delete, then click the Delete button
.
- Click OK.
Change the formatting for a rule
- Click in the column with the conditional formatting rule, then choose .
- From Rules, select the rule.
- Click Format.
- Select a Background color, a Font Color, and a Font Style for the cell formatting.
- Click OK in each dialog box.
