Forum Discussion
Conditional Formatting for Icons
Hello all, Im adding conditional formatting icons to the matrix and the icons are not getting updated according to the condition applied. unable to figure out the issue tried many ways, Can someone ...
Hi Anonymous ,
Are you sure if your Sum CM column is having data as a %.
In case if you have applied % as a data format on top of numbers your conditional formatting might not work as it will get input as Numbers.
i.e. Your 34% might be 0.34 as per the originial data without data format of % applied.
In such case, instead of applying conditional formatting on %, try doing it on Numbers, with 0 as min value and 1 as Max Value. i.e. 100% is 1, 40% is 0.4, 34% is 0.34 etc.
Regards,
This worked. Thank you soo much for the solution