By Allen Wyatt for Excel.Tips.Net
How to Delete Microsoft Excel 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.
This post appears with permission from Allen Wyatt and Excel.Tips.Net.
