Pivot table conditional formatting

Hi,

You can do this with 4 rules following these steps.

1. Select one of the value cells in the pivot table.
2. Create a new conditional formatting rule and make sure it applies to all Price cells
3. Use the formula: =NOT(ISNUMBER(INDIRECT("RC[-1]",0))) then apply yellow format (this will colour the first column)
4. Repeat steps 2 and 3 but use Cell Value, Is equal to, =INDIRECT("RC[-1]",0) then apply yellow format (this will colour cells that are equal)
5. Repeat steps 2 and 3 but use Cell Value, Is greater than, =INDIRECT("RC[-1]",0) then apply Red format (this will colour cells that are greater than the previous)
6. Repeat steps 2 and 3 but use Cell Value, Is Less than, =INDIRECT("RC[-1]",0) then apply Green format (this will colour cells that are less than the previous)

Revised workbook attached.