Can I make negative percent changes appear in red?

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?

[Mark O'Brien]

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.

[Mark W.]

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 ]

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

[Jack in the UK]

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.

[Jack in the UK]

ALL

Sorry guys i dont understand

parentheses

please understand explaining me for please!

many thanks

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.

Jack, parentheses are the () symbols.

Thanks all for your help!

[Aladin Akyurek]

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.

[Mark W.]

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 ]