How can I make a conditional formatting in a Pivot Table?
I mean, I want to make background RED If the value is less than 0.
What formula should I write the background color expression?
Please find attached.
Thanks in advance.
You should try the following expression:
Thank you for your answer undergrinder
You can use the expression which under grinder provided an will work perfectly. If you have any complex colour expressions you can even make use of ColorMix() function to achieve it.
Retrieving data ...