Forum Discussion
YavuzDuran
2 years agoHelper III
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 ?
- 2 years ago
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
marcelsmaglhaes
2 years agoSuper User
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
- YavuzDuran2 years agoHelper III
This worked. Appreciated.