Create your pivot table. Select your data set in your pivot table; then click the Format tab.
Select Conditional formatting.
Add your conditions.
You will add one rule per condition.
Your end result will look like this:
Create your pivot table. Select your data set in your pivot table; then click the Format tab.
Select Conditional formatting.
Add your conditions.
You will add one rule per condition.
Your end result will look like this: