Conditional formatting negative value

[rsch91]

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. 

[miTutorials · Accepted solution]

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%. 

[rsch91]

Of course, makes a lot of sense. Thank you. It's worked.