Create your pivot table. Select your data set in your pivot table and 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 and 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: