Controlling how multiple rules are applied


show more Controlling how multiple rules are applied 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 ...

Controlling how multiple rules are applied

Excel lets you create many types of conditional formats and it gives you many ways to manage those rules. For example, in Excel 2003 and earlier each cell could have up to three conditional formatting rules applied to it. What's more, only one of those rules could be applied at the same time. When Excel discovered that one rule is true it simply stopped checking. In Excel 2010, there is no practical limit to the number of conditional formatting rules you can apply to a cell. It's also possible for more than one conditional formatting rule to be applied at the same time.

So let's say that you have applied a number of conditional formatting rules to your PivotTable and you want to go in and manage how they are applied. To do that click any cell in the body of the PivotTable and then on the Home tab click Conditional Formatting and then at the bottom of the menu that appears click Manage Rules. When you do the Conditional Formatting Rules Manager appears and it lists each of the fo...

Controlling how multiple rules are applied
Video duration: 3m 28s 3h 43m Intermediate

Viewers:

Controlling how multiple rules are applied 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 ...