How to remove conditional formatting in MS Excel

Conditional formatting is a useful feature but there are times that you need to remove either all the conditional formatting or else the conditional formatting on specific cells. Below two ways of how to remove conditional formatting in MS Excel.

YouTube Remove conditional formatting

Watch, like, subscribe

Remove conditional formatting by pointing at cells

Probably easiest is to point at the cells you want to clean of conditional formatting. As shown below,

  • highlight the cells,
  • click on the HOME ribbon, then
  • choose from the Clear Rules option.

Note that you can clear conditional formatting from the entire sheet (ignoring whether you have highlighted the cells or not) or clear conditional formatting from the selected cells only.

How to remove conditional formatting in MS Excel

More controlled way of clearing conditional formatting in MS Excel

A more controlled way would be to use the Manage Rules option in the conditional formatting dropdown.

In this case, once you open it up (on the HOME ribbon, CONDITIONAL FORMATTING, MANAGE RULES), you can control various aspects. Firstly note that you can ‘Show formatting rules for’ various options (selection, this worksheet, other worksheets). You have the ability then to look at all the conditional formatting that exists in that sheet and decide which must go. If it is all then just highlight them all and click the ‘Delete Rule’ button. But if it is only some, you can easily specify which ones.

How to remove conditional formatting in MS Excel

If you don’t want to delete the conditional formatting, only pause it, have a look at the tip on pausing conditional formatting in Microsoft Excel.

Want to learn more about Microsoft Excel? If you prefer attending a course and live in South Africa look at the Johannesburg MS Excel 3 Day Advanced Course  or the Cape Town MS Excel 3 Day Advanced training course. If you prefer online learning or live outside South Africa, look at our online MS Excel training courses.

REMOVE current selection from data filter

Conditional formatting based on another sheet

Change cell color based on value of cell