Skip to main content
Announcements
Accelerate Your Success: Fuel your data and AI journey with the right services, delivered by our experts. Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Change background color in pivot table

Dearest members,

Currently I am struggling with the background color of a pivot table where I compare two (or in the future multiple) years, see screenshot of the table below;

PrtScr.png

What I would like to get done is that when the value of 2016 is higher than the value of 2015 to turn it into red and vice versa. I've already tried several options with RowNo() etc. but I cannot get it done Could you guys please help me out??

All input is much appreciated. Thanks!!

Kind regards, Jeffrey

1 Reply
girirajsinh
Creator III
Creator III

try something like following