Thanks Thanks:  0
Likes Likes:  0
Page 2 of 2 FirstFirst 12
Results 11 to 18 of 18

Thread: Can I make negative percent changes appear in red?

  1. #11
    Guest

    Default

    Sorry, I'm not being clear. I don't need the negative sign any longer, I just want the negative numbers to appear in red, with parentheses, without the '-' sign.

  2. #12
    Legend NateO's Avatar
    Join Date
    Feb 2002
    Location
    Minneapolis, Mn, USA
    Posts
    9,700
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    You could select the cells, right-click, select format, choose custom at the bottom and enter or paste:

    0.00%;[red](0.00%)


    Into the appropriate area. Click OK.

    (As Mark said while I was typing )

    Cheers, Nate


    [ This Message was edited by: NateO on 2002-03-13 13:58 ]

  3. #13
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Austin, Texas USA
    Posts
    11,654
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    And use...

    0.00%_);[Red](0.00%)

    ...if you want to keep your numbers aligned.

    [ This Message was edited by: Mark W. on 2002-03-13 14:03 ]

  4. #14
    Guest

    Default

    Perfect. Thanks fellas!

    So how does that sequence tell Excel to filter out the negatives that way?

  5. #15
    Board Regular
    Join Date
    Feb 2002
    Posts
    3,184
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default


    Celect the cells / range reqd
    Right click
    format cells

    opt for custom and copy this in:
    [Green]0.00%;[Blue]-0.00%

    left of ; id positive and right of ; is negative so :
    + = auto colour
    - = red colour

    now i dont like red as i cant see it so can change as i do to BLUE, this is 100% exceptable in Finance arround the world on SSheets, or as i have often done with some results ie dates and % SPLIT THEM

    [Green]0.00%;[Blue]-0.00%

    green is bright but im intrested in credits for this not debts

    Try combinations of these:
    [Red]0.00%;[Blue]-0.00%
    Yellow
    Black
    Green


    0.00%;[Red]-0.00%
    Free Excel based Web Toolbar available here.

    Jack in the UK
    J & R Excel Solutions
    "making Excel work for you"

  6. #16
    Legend NateO's Avatar
    Join Date
    Feb 2002
    Location
    Minneapolis, Mn, USA
    Posts
    9,700
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    There's two sides. The first is what to do on positive, the second says what to do on negative side.

    Cheers, Nate

    [ This Message was edited by: NateO on 2002-03-13 14:37 ]

  7. #17
    Guest

    Default

    Gotcha. Thanks again, guys.

  8. #18
    MrExcel MVP
    Join Date
    Mar 2002
    Location
    Michigan USA
    Posts
    11,454
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Well how about if you use the following number format:
    0.00%;[Red](0.00%)
    Now the negative numbers will be in red, but without the negative sign, and of course with the percent symbol.
    Hope This Helps!

    Edit: sorry, I see this has already been covered in this very thred

    [ This Message was edited by: Yogi Anand on 2002-05-25 15:06 ]

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •