Edit Conditional Formatting Rules in PivotTables


show more Editing conditional formatting rules 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 ...

Editing conditional formatting rules

After you create a conditional formatting rule, you might need to change it to reflect new operating additions or goals of your company. For example, you might revise your sales targets to reflect an economic downturn or you could decide to pay a bonus to the top 15% of your sales representatives instead of your top 10 because you had a great year. To edit a conditional format, you click any cell that contains the format as I've done here, and then on the Home tab of the Ribbon, click the Conditional Formatting button and then click Manage Rules.

When you do, the Conditional Formatting Rules Manager dialog box appears and then you can click any rule that you want to edit. In this case there's only oneso I will click it. So it's highlighted in blue and then to open the editing box I'll click the Edit Rule button. You can use the controls in the Edit Formatting Rule dialog box to change every aspect of your conditional format, including the type of rule, the cells to which...

Editing conditional formatting rules
Video duration: 2m 15s 3h 43m Intermediate

Viewers:

Editing conditional formatting rules 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 ...