Can I make negative percent changes appear in red?

G

Guest

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?
 

Excel Facts

When they said...
When they said you are going to "Excel at life", they meant you "will be doing Excel your whole life".
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.
 
Upvote 0
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
 
Upvote 0
Great, thanks!
No way to do the parentheses, then, I take it? Or that's probably pretty complex?
 
Upvote 0
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.
 
Upvote 0
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.
 
Upvote 0
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.
 
Upvote 0
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
 
Upvote 0

Forum statistics

Threads
1,213,536
Messages
6,114,207
Members
448,554
Latest member
Gleisner2

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top