Forum Discussion
Post PatronConditionally formatting half working for negative numbers
I've got a table I've got conditional formatting on...and I can kinda get it to work...but not fully.
In the example, its -21 so it should be dark red...but its going light red what should be only if its -15 to 0.
Can anyone get this to work proper with negative values?
Thanks!
I notice you are using a percentage. Is it marked as type percentage? Generally this is stored as a number 100 times smaller than what is displayed so -21% will be stored as -0.21.
With the condition formatting, if the number is a percentage, you'll need to write the values as decimal values. So it should be 10, 0.15, 0, and -0.15 and -10 for your conditions.
2 Replies
I notice you are using a percentage. Is it marked as type percentage? Generally this is stored as a number 100 times smaller than what is displayed so -21% will be stored as -0.21.
With the condition formatting, if the number is a percentage, you'll need to write the values as decimal values. So it should be 10, 0.15, 0, and -0.15 and -10 for your conditions.
unclejemimaYou are correct my friend! Marked as the solution! It was the decimals...
Silly me, I'm glad this was a quick easy fix :-)