Forum Discussion

virakprom's avatar
virakprom
Frequent Visitor
7 years ago
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.

  • virakprom's avatar
    virakprom
    7 years ago

    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

  • Anonymous's avatar
    Anonymous
    Not 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

  • 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.

    • virakprom's avatar
      virakprom
      Frequent Visitor

      It isn't working. but I want show percentage not decimal

      • Tahreem24's avatar
        Tahreem24
        Super User

        Hi virakprom ,

         

        Please set the your conditional formatting as per screen shot below and let me know your result:

    • Anonymous's avatar
      Anonymous
      Not applicable

      The best simply solution ever, thank you.

  • 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 elements

    Turn 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”.

     

     

  • virakprom's avatar
    virakprom
    Frequent 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

    • jdbuchanan71's avatar
      jdbuchanan71
      Super User

      virakprom 

      Can you show me a screen shot of your rule with greater than -1 (NEGATIVE 1) and NUMBER and less the 0 number.

      • roma's avatar
        roma
        Advocate II

        Try this for Positive and Negative numbers

         
    • LukeDexters's avatar
      LukeDexters
      Regular Visitor

      Hi,

       

      This is possible by using a gradient with custom values.