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!
Thanks, will I be able to write the values as percentages in the future?
I put it on our development plan.
This topic was automatically closed 2 days after the last reply. New replies are no longer allowed.