Forum Discussion
Conditional formatting is not working for decimal data type and % format
Community ChampionHi LakshmiSree
first, I see a hole in your statement.
values between 60 and 61 and values between 80 and 81 will not be affected by conditional formatting rules
second, how do you get a column "Average ofCTC Reliability (%)" on screenshot? is it a measure (if yes, show a formula) or just aggregation in visual?
do not hesitate to give a kudo to useful posts and mark solutions as solution
What I observed is, If I apply for one column its working fine. If I apply for multiple columns its not working properly.
- az38
well, I think the key is not in conditional formatting. it's about correct average calculate. you need to define how to you want to calculate it. what filter should be applied to statement and so on. next, check your formula and real data. then, conditional formatting should work ok
do not hesitate to give a kudo to useful posts and mark solutions as solution