Formatting Pivot table cell background

[#1]

Hi,

Is there a way to chnage the cell background based on the value of precious cell.

For Eg: If cell1 > cell2 then green() else Red().

I have used background colour expressions based on the dimension values and cell value thresholds, but not by comparing two cells.

Please let me know if anybody has tried this already.

Thanks,

Shruthi Reddy

[tresB]

May be like:

If( Before(Sum(Sales))> Sum(Sales), green(), Red())

[#3 · Accepted solution]

Yes, I got it working.

If the dimension is shown vertical then If( Above(Sum(Sales))> Sum(Sales), green(), Red())

If the dimension is shown horizontal If( Before(Sum(Sales))> Sum(Sales), green(), Red())