Conditional formatting based on dynamic values in matrix

[KanchanSingh]

Hi,

I have a requirement of colour coding cell backgrounds if it is beyond lower and upper thresholds. These lower and upper limits are 2 different columns. 

I have seen some workarounds here  i.e add another column to assign static value and configure conditional formatting on that column. But this is not going to help me in this case. As I need to show the report in matrix form this will make the report look very clumsy.

Is there any other solution we can try?

Regards,

Kanchan

[v-chuncz-msft]

@KanchanSingh,

So far, there is no elegant way. You may try to create a custom visual.