Forum Discussion
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
3 Replies
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 [numberThis worked. Appreciated.
In the first rule you are mixing percentage and number. Did you intend to do that?
