Hide

Removing only one rule of Conditional Formatting

You can download here the worksheet from this video to practice it by yourself!

Removing a specific rule from conditional formatting

Sometimes a range is conditionally formatted by more than one rule. Let’s have look at the following example:

In the weekly allowance column we’ve got two rules:
If greater than $14 then green color.
If smaller than $10 then red color.

A range that is conditionaly formatted with two rules

Let’s get rid of the first rule only (the green):
Start by Selecting the relevant data range.
Click the “Conditional Formatting” button, and choose: “Manage Rules…”

The menu for entering Manage Rules in Excel Conditional Formatting

In the dialog box that has opened you can see two rows representing the two rules:

The Manage Rules dialog box for Conditional Formatting

Select the rule you wish to remove (by clicking it).
Click the “Delete Rule” button.
Then click OK.

That's it!

You can see on the following image that the rule “greater than 14 will be green” has been removed.

A range with only one rule of conditional formatting left