C
Caros
I have a problem with conditional formatting when using percentages which I
will try to explain.
I am using "Format all cells based on their value"
Format Style = Icon Sets
Reverse Icon Order is selected.
Red traffic light when value is >= 90 percent
Orange traffic light when < 90 and >= 80 percent
Green traffic light when < 80
All cells have been formatted as percentage.
However the conditional formatting applied is not as expected.
A1 = 50%
Expected result = Green
Actual restul = Green
A2 = 80%
Expected result = Orange
Actual result = Red
A3 = 70%
Expected result = Green
Actual result = Orange
If I change this to numbers, then the results are correct.
Any thoughts appreciated
Caroline
will try to explain.
I am using "Format all cells based on their value"
Format Style = Icon Sets
Reverse Icon Order is selected.
Red traffic light when value is >= 90 percent
Orange traffic light when < 90 and >= 80 percent
Green traffic light when < 80
All cells have been formatted as percentage.
However the conditional formatting applied is not as expected.
A1 = 50%
Expected result = Green
Actual restul = Green
A2 = 80%
Expected result = Orange
Actual result = Red
A3 = 70%
Expected result = Green
Actual result = Orange
If I change this to numbers, then the results are correct.
Any thoughts appreciated
Caroline