Color in pivot table

[harveenkaur]

Hi

I want to color the fields in pivot table as shown in sample data below.(Red indicates the area where  growth of city is less comparative to country growth and green in vice versa case. Growth has been calculated as CY/LY-1

[hopkinsc]

Hi

You just need an IF() statement on the background colour of the expression.

IF(CY<LY-1,Red(),Green())