topic Re: Pivot table cell background color based on conditional formatting in App Development

Pivot table cell background color based on conditional formatting

dia2021 — Tue, 30 Nov 2021 18:17:33 GMT

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?

Re: Pivot table cell background color based on conditional formatting

Sweta_Sharma — Sat, 17 Jul 2021 07:26:28 GMT

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!

Re: Pivot table cell background color based on conditional formatting

dia2021 — Mon, 19 Jul 2021 14:13:35 GMT

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%

Re: Pivot table cell background color based on conditional formatting

dia2021 — Thu, 22 Jul 2021 15:38:39 GMT

@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!