Pivot table cell background color based on conditional formatting

[dia2021]

Hi All,

Is it possible to set up the background color in the pivot table, for example

I want the cell background color to turn green when it's 100% and Gray when it's 0%. How can I achieve this?

[Sweta_Sharma · Accepted solution]

Hi @dia2021 ,

You can achieve this by using expression for background color-
Edit sheet>> Data>> Dimension/ Measure>> Set 'Background color expression' if(Value=100, Green(), rgb(128, 128, 128))

Cheers!

[dia2021]

Hi Sweta,

Thanks for your reply. I set up on measure background expression, but its applying on the whole table rather than on the cell that contains values 100%

[dia2021 · Accepted solution]

@Sweta_Sharma  Your expression is correct. I found a bug in the app that was not accepting value 0.01 for 100% but it worked with condition  >0.99. Thanks!