Deleting Conditional Formatting

Conditional formats, to Excel, are just like any other format. That means that you can delete them by simply deleting all the formatting in a cell. Follow these steps:

1. Select the cell or cells whose formatting you want to delete.
2. Display the Home tab of the ribbon.
3. In the Editing group, click Clear | Clear Formats.

That's it. All the formatting is removed from the cells, including any conditional formatting. If you don't want to delete any explicit formatting in the cell, but instead want to delete just the conditional formats, follow these steps:

1. Select the cells from which you want to delete the conditional formatting.
2. Display the Home tab of the ribbon.
3. In the Styles section, click Conditional Formatting. Excel displays various options related to conditional formatting.
4. Choose Clear Rules | Clear Rules from Selected Cells.

If you don't want to delete all the conditional formatting rules, then you need to follow these steps, instead:

1. Select the cells from which you want to delete the conditional formatting.
2. Display the Home tab of the ribbon.
3. In the Styles section, click Conditional Formatting. Excel displays various options related to conditional formatting.
4. Click Manage Rules. Excel displays the Conditional Formatting Rules Manager. (Click here to see a related figure.)
5. From the list of available rules, select the one you want to delete.
6. Click Delete.
7. Repeat steps 5 and 6 for any other rules you want to delete from the selected cells.
8. Click OK to close the Conditional Formatting Rules Manager dialog box.