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!