Deleting a conditional formatting rule


show more Deleting a conditional formatting rule provides you with in-depth training on Business. Taught by Curt Frye as part of the Excel 2010: Pivot Tables in Depth show less
please wait ...

Deleting a conditional formatting rule

Conditional formats help you make judgments about your data quickly, but you might find that one or more of the rules you created that are no longer useful. If that's the case you can delete rules individually from the Conditional Formatting Rules Manager or get rid of them all by using the controls on the Home tab of the Ribbon. If you want to delete a single rule then on the hometown of the Ribbon click Conditional Formatting and then click Manage Rules. Then in the Conditional Formatting Rules Manager dialog box you can select the rule that you want to delete.

So for example if we wanted to delete the rule that identifies the top seven values then I could click it and then click Delete Rule. You should always verify that any remaining rules operate the way you want them to. For example, if the rule you got rid of, how to Stop If True condition, you might have disrupted the rules logic and cause Excel to apply rules it shouldn't. When you are done managing the rules inside thi...

Deleting a conditional formatting rule
Video duration: 2m 11s 3h 43m Intermediate

Viewers:

Deleting a conditional formatting rule provides you with in-depth training on Business. Taught by Curt Frye as part of the Excel 2010: Pivot Tables in Depth

Subject:
Business
Software:
Excel
Author:
please wait ...