Removing only one rule of Conditional Formatting
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.
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…”
In the dialog box that has opened you can see two rows representing the two rules:
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.