How to Delete Microsoft Excel Conditional Formatting

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.

Article Continued Here

This post appears with permission from Allen Wyatt and Excel.Tips.Net.

104 total views, 1 views today

(Visited 5 times, 1 visits today)

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.