Forum Discussion
Solved
Conditional Formatting < 0?
Hi, How can we use conditional formatting with negative values? I have year on year percentage change which can be either positive or negative. Either I'm acting really dumb or just having a bad ...
You can format by rule with negative number (rather than percentage) to format the yoy declines. -1 = -100%:
You can format by rule with negative number (rather than percentage) to format the yoy declines. -1 = -100%:
Thank you so much ... I'm just having one of those bad hair days where I couldn't work the stupid thing out.
Cheers