Thanks Thanks:  0
Likes Likes:  0
Page 1 of 2 12 LastLast
Results 1 to 10 of 18

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

  1. #1
    Guest

    Default

    I have a column that's just percent changes, and rather than leaving it as a number and setting the negatives to red and in parentheses, I need to have it with the percent sign. Is there a way to show the percent return yet still be able to show the negative returns in red?

  2. #2
    MrExcel MVP Mark O'Brien's Avatar
    Join Date
    Feb 2002
    Location
    Columbus, OH, USA
    Posts
    3,530
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Select the cells with the percentages and go to Format|Conditional Formatting and set up your rules for the colours there.

    e.g. If value is less than 0% put the font colour to red.

  3. #3
    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

    On 2002-03-13 13:39, Anonymous wrote:
    I have a column that's just percent changes, and rather than leaving it as a number and setting the negatives to red and in parentheses, I need to have it with the percent sign. Is there a way to show the percent return yet still be able to show the negative returns in red?
    I'm puzzled. Can you provide some sample data? Maybe the following custom format will do the trick...

    0.00%;[Red]-0.00%

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

  4. #4
    Guest

    Default

    Great, thanks!
    No way to do the parentheses, then, I take it? Or that's probably pretty complex?

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

    Default

    Hi

    I think we can do that.

    Highlight the cells / range to foramt.
    Click format
    click conditional format
    change drop downs to

    cell value is
    less than
    and copy this in to the last box

    0

    that should do it

    Format the cells to % nad the numbers less than 0% will be red inculding the % part.


    Free Excel based Web Toolbar available here.

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

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

    Default

    ALL

    Sorry guys i dont understand

    parentheses

    please understand explaining me for please!

    many thanks


    Free Excel based Web Toolbar available here.

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

  7. #7
    Guest

    Default

    Hey Mark, the column if I format the cells to "Number" looks like this:

    0.05
    (0.10)
    0.10
    0.25
    0.40
    (0.19)
    And the negative numbers are in red and in parentheses

    If I format the cells as "Percentage", I get:
    0.05%
    -0.10%
    0.10%
    0.25%
    0.40%
    -0.19%

    So I want to keep the percent signs, but still keep the negatives in red and in parentheses.

  8. #8
    Guest

    Default

    Jack, parentheses are the () symbols.

    Thanks all for your help!

  9. #9
    MrExcel MVP Aladin Akyurek's Avatar
    Join Date
    Feb 2002
    Location
    The Hague, NL
    Posts
    83,572
    Post Thanks / Like
    Mentioned
    30 Post(s)
    Tagged
    6 Thread(s)

    Default

    On 2002-03-13 13:49, Anonymous wrote:
    Hey Mark, the column if I format the cells to "Number" looks like this:

    0.05
    (0.10)
    0.10
    0.25
    0.40
    (0.19)
    And the negative numbers are in red and in parentheses

    If I format the cells as "Percentage", I get:
    0.05%
    -0.10%
    0.10%
    0.25%
    0.40%
    -0.19%

    So I want to keep the percent signs, but still keep the negatives in red and in parentheses.
    -(0.4) would become a positive number. Parens designate a negative number.

  10. #10
    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

    On 2002-03-13 13:49, Anonymous wrote:
    Hey Mark, the column if I format the cells to "Number" looks like this:

    0.05
    (0.10)
    0.10
    0.25
    0.40
    (0.19)
    And the negative numbers are in red and in parentheses

    If I format the cells as "Percentage", I get:
    0.05%
    -0.10%
    0.10%
    0.25%
    0.40%
    -0.19%

    So I want to keep the percent signs, but still keep the negatives in red and in parentheses.
    Okay. Format as...

    0.00%;[Red]-0.00%

    ...to get...

    5.00%
    -10.00%
    10.00%
    25.00%
    40.00%
    -19.00%

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

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
  •