Conditional Formatting, color does not match with the Rule

[YavuzDuran]

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 ? 

[KEAlexander]

In the first rule you are mixing percentage and number. Did you intend to do that?

[marcelsmaglhaes · Accepted solution]

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

[YavuzDuran]

This worked. Appreciated.