Forum Discussion
Conditional formatting on table % not correct
I have a table with a column showing percentages, on this column I have set up conditional formatting with rules seen below. Values showing as 100% are not following the set rules correctly. Showing ...
Anonymous you have 2 condition with <= 1. Check that out.
for yello it should be >= 0.85 < .99999
for green it should be >= .99999 <=1
Anonymous Did I answer your question? Mark my post as a solution!