Edit Ordering, And Deleting Conditional Formats In Excel For Mac


show more Editing, ordering, and deleting conditional formats provides you with in-depth training on Business. Taught by Curt Frye as part of the Excel for Mac 2011 Essential Training show less
please wait ...

Editing, ordering, and deleting conditional formats

After you've created one or more conditional formats, you can edit, reorder, and delete the rules as necessary. In this movie, I'll show you how to manage the rules you've created. In this worksheet, I have a set of cells, B4:B14, that all have conditional formatting applied. They all use the same rule. I applied them at the same time. So, I'm going to select these cells. And now to edit the rules, I click on the Home tab of the Ribbon > Conditional Formatting, and at the bottom of the menu that appears, there is Manage Rules.

So I'll click that, and Excel displays the Manage Rules dialog. So, here are the two rules that I have applied to these cells. Any cell with a value greater than .85, or 85%, will be displayed with a red background. For this rule, any cell with a value greater than .8, or 80%, will be displayed in bold. If I want to edit one of these rules, I can click the rule and in this case I'll just work with the rule that's already selected, the...

Editing, ordering, and deleting conditional formats
Video duration: 3m 36s 6h 32m Beginner

Viewers:

Editing, ordering, and deleting conditional formats provides you with in-depth training on Business. Taught by Curt Frye as part of the Excel for Mac 2011 Essential Training

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