Forum Discussion
Solved
Conditional Formatting, color does not match with the Rule
Hi everyone, I created a conditional formatting as you will se below, the first rule requires that %117.1 should be green but it shows as orange. This is a measure btw Any idea ?
Hey YavuzDuran
You should replace the Percent by Number in conditions.
If this post helps, please mark as solved.
Regards,
Marcel> = 0.9 [Number] and < 99999 [number] (9999 is an aleatory number which represents a number that is less than the highest percentage you have)
>= 0.8 [number] and < 0.9 [number]
>= 0 [number] and < 0.8 [number
In the first rule you are mixing percentage and number. Did you intend to do that?