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:
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.
Do it like thousands of other people who have used SeaTable to develop powerful processes and get their ideas and tasks done more efficiently.
