Can I make negative percent changes appear in red?

[Guest]

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?

 

[Guest]

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.

 

[NateO]

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

 

[Mark W.]

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

 

[Guest]

Perfect. Thanks fellas!

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

 

[Jack in the UK]

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%

 

[NateO]

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

 

[Guest]

Gotcha. Thanks again, guys.

 

[Yogi Anand]

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