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