Color column cells based on rules - not working

I have set up this colour scheme :

for the values calculated by a formula in the column on the left:

As you can see, it is not working - Both cells are red, but they should be green.

As a control, I recreated the rules and the numbers in the column on the right, but this time as a normal number column:

As you can see, it also didn’t work. Please advise.

I could reproduce the problem. The root cause is that the conditional formatting rules do not interpret percent values correctly. When entering the values in decimal notation, it works:

Apologies for the inconvenience!

1 Like

Thanks, will I be able to write the values as percentages in the future?

I put it on our development plan.

1 Like

This topic was automatically closed 2 days after the last reply. New replies are no longer allowed.