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

Select the cabinet or cells whose formatting you desire to delete.Display the home tab that the ribbon.In the editing group, click clear | clear Formats.

You are watching: What feature is used to delete a conditional formatting rule

That"s it. Every the formatting is removed from the cells, including any conditional formatting. If friend don"t want to delete any explicit formatting in the cell, however instead desire to delete just the conditional formats, follow these steps:

Select the cells from i beg your pardon you desire to delete the conditional formatting.Display the residence tab that the ribbon.In the formats section, click Conditional Formatting. Excel display screens various choices related come conditional formatting.Choose clear Rules | clean Rules indigenous Selected Cells.

If you don"t want to delete every the conditional formatting rules, climate you need to follow this steps, instead:

Select the cell from i beg your pardon you want to delete the conditional formatting.Display the house tab the the ribbon.In the layouts section, click Conditional Formatting. Excel display screens various alternatives related come conditional formatting.Click regulate Rules. Excel displays the Conditional Formatting rules Manager. (See figure 1.)

*

figure 1.

See more: What Does The Vsepr Theory Tell About A Molecule S, How Is The Vsepr Theory Used

The Conditional Formatting rule Manger.

From the perform of obtainable rules, choose the one you desire to delete.Click Delete Rule.Repeat measures 5 and also 6 for any kind of other rules you want to delete from the selected cells.Click OK come close the Conditional Formatting rules Manager dialog box.