Forum Discussion
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
24 Replies
- AnonymousNot applicable
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
- jdbuchanan71Super User
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.
- jhauff_RFOAdvocate I
Conditional Format Matrix to Red/Black
1) Create a Matrix visual by going to Build and clicking on the Matrix Icon
2) Enter a value into the Values field
3) Click on the Format Icon
4) Choose Cell elementsTurn Font Color (or other option) to "On" > Click on the fx icon
Choose Rules from the "Format style" dropdown (see screen shot below)
Choose "Values and totals" from the "Apply to" dropdown
Keep the "What field should we base this on?" dropdown as is.
Rules Value Options:
1) Choose greater than ">" from the 1st "If value" dropdown. Go to the next field.
2) Enter a very large negative number, e.g., -100000. Go to the next field.
3) Choose Number from the dropdown (see Note below).
4) Follow the screen shots below for the other Rules values.Note: There seems to be a glitch in how the “Apply to” dropdown and the “value dropdown” interact.
If the 3rd field of the Rules dropdown (1) does not show "Number" as a option, change the "Apply to" dropdown (2) to "Value only".
"Number" should now appear as an option in the 3rd field of the Rules "If value" dropdown (1).
Change the 3rd "If value" dropdown (1) to Number, then go back and change the "Apply to" dropdown (2) to “Values and totals”.- Alexa1988New Member
This resolved my issue! Thanks for that!
- virakpromFrequent Visitor
Thank all of you contribute to help me solve this issue. but It still not working all your mention above.
I think It's bug or error on this issue. I need to extra field in order to show red on negative values.
It doesn't make sense, right ? Why it need to add one more field in table in order to work ?
But my requirement don't need it
you can see picture at below- jdbuchanan71Super User
Can you show me a screen shot of your rule with greater than -1 (NEGATIVE 1) and NUMBER and less the 0 number.
- romaAdvocate II
Try this for Positive and Negative numbers
- AgnieszkaFNFrequent Visitor
Thanks! That resolved the issue! 🙂
- LukeDextersRegular Visitor
Hi,
This is possible by using a gradient with custom values.