Forum Discussion
Solved
Conditional formatting negative numbers red
Anyone know how set Conditional formatting rule on negative numbers to red ? I want negative numbers or percentage to red. I try to set minimum field to blank but it don't allow me to set it. ...
jdbuchanan71
Very appreciate for your effort to me.
Thank for your support.
Now this issue found already.
This picture at below that I got email from Microsoft
Hello virakprom
You can change the type from percent to number and put a negative amount in the first field. The formatting below will format negative % from -100% to 0 as red.
The best simply solution ever, thank you.