Conditional formatting can be removed in two different ways:
A) Deleting formatting rules
When you delete a conditional formatting rule, it will be removed from all cells it was defined for – no matter if you have currently selected cells in the worksheet or not.
Proceed as follows:
| 1. | Choose the ribbon command Home | group Format | Conditional formatting | Manage rules. |
| 2. | A dialog box appears. |
| Note: By default, this dialog box displays only the rules for the current cell (or selection). If you want to see all rules created in the entire worksheet instead, set the Source option to Current worksheet. |
| 3. | Select the rule to be deleted in the Rules list. |
| 4. | Click on the Delete button. |
This will delete the rule – and accordingly remove it from all cells it was defined for.
B) Removing all conditional formatting from a cell range
There's another method for removing conditional formatting, which removes all conditional formatting from a particular cell range.
Proceed as follows:
| 1. | Select the cells from which you want to remove all conditional formatting. |
| 2. | Choose the ribbon command Home | group Format | Conditional formatting | Delete rules in selected cells. |
(Alternatively, under Home | group Contents | Delete  , use the command Conditional formatting, which does exactly the same thing.) |
This will "free" the selected cells from any conditional formatting rules applied to them.
Formatting rules that become superfluous because of that will be deleted automatically.