Pivot Table Conditional Formatting

Pivot Table Conditional Formatting

Inserting a Pivot Table is very easy to do in Microsoft Excel: Inserting a Pivot Table

Adding some Conditional Formats to the Pivot Table allows a user to highlight key data in a split second.

See how easy it is to add some color to your analysis.

download workbookCond-Format-a-Pivot-Table.xlsx

STEP 1: We want to create a rule that will highlight values greater than 100,000

Select any cell inside the Pivot Table

STEP 2: Go to Home > Conditional Formatting > New Rule

STEP 3: Select the following settings. We are selecting the third option so that the formatting rules only apply to the individual cell values

Click Format

STEP 4: Select Fill and pick a color of your choice

Click OK twice

The formatting rule is now applied to your entire Pivot Table!