Pivot Table Cell Color

[vanderson009]

Hi,

I have below data in pivot table,

I want to change background color of cell based on condition if previous year sales is less than current then cell background is green else red.

Thanks,

Villyee

[petter]

• Go to the properties dialog of the Pivot Chart.
• Select the "Expressions" tab.
• Click the + icon to the left of the Sum(Sales) expression.
• Then select "Background Color" and in the "Definition" add the expression
  If( Before(Sum(Sales)) < Sum(Sales) OR ColumnNo()=1 , Green(100),Red(100))
• Click OK.

[mtucholski]

if(before(sum(Sale))<sum(Sale),lightgreen(),lightred())