Forum Discussion
Solved
Conditional formatting negative value
Hi,
I'm trying to format a table conditionally. The table contains negative values, data type is percentage. Anything over 15%, positively or negatively, should be red. Anything within the -15% and 15% range should be green. See below for the settings I'm using. Everything's turning out green.. even values of 40% or -25%. Help, what did I do wrong?
'Getal' means number.
Since the data type is percentage - when you enter 15 it turns out to be 1500%. You will have to change the value to 0.15 for 15% and 1 for 100%.
2 Replies
Since the data type is percentage - when you enter 15 it turns out to be 1500%. You will have to change the value to 0.15 for 15% and 1 for 100%.
Of course, makes a lot of sense. Thank you. It's worked.
