Can someone help me do the following conditional formatting:
conditional formatting in pivot table by comparing each row to the previous one and color the cells accordingly. (multiple rows exist)
If cell (I,j) > cell(I-1,j) --> red
If cell (I,j) < cell(I-1,j) --> green
else no format
Any hint for the above question?
if(yourExpression> Above(yourExpression), green(),Red())
if(sum([Car sales])> Above(sum([Car sales])), green(),Red())
Thanks! Works like a charm.......
Also, is there a way to do this from the 'left cell' (not above)?
Got it, just use before() instead of above().
yes there is ...
use before() instead above() :
if(sum([Car sales])> before(sum([Car sales])), green(),Red())
Hope it helps
Thank you very much. It worked fine
If your question is now answered, please flag the Correct Answer (via the big "Correct Answer" button near every post).
If not, please make clear what part of this topic you still need help with .
Thank you, it was really helpful.
Retrieving data ...