Forum Discussion
KanchanSingh
8 years agoRegular Visitor
Conditional formatting based on dynamic values in matrix
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
1 Reply
- v-chuncz-msftCommunity Support