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
In Field formatting, use Red as default color for this column. This would render all values (negative or positive) in Red color.
Then use Conditional formatting to color the positive values in Green. The conditional formatting would look something like this:
Format by Rules
Based on Field
<Your Numeric Column Name>
Rules
If value is greater than or equal to 0 Number and is less than or equal to <a very large number> Number then Green
Please mark it as accepted solution if works.
Thanks and regards,
Jitendra Pandey