Format color - darker green available?

D

DrB

Using number format custom to have my numbers come out green or red
depending upon + or - values. The green in [Green0%;Red0%] is too light. I
want to use dark green, but if I put that in it does not work. Is there a
way to get Dark Green to show up in above formatting?
 
D

Dave Breitenbach

If its only for negative vs positive numbers. Use a format with no colors in
the column and then use conditional formatting with 2 conditions - one for
negative numbers and one for positive numbers. (under format puuldown menu)

hth
 
D

DrB

I tried conditional formatting and decided with number formatting for some
reason some time back with this data. So is there any other choices on
colors with number formatting besides black and red?

Dave Breitenbach said:
If its only for negative vs positive numbers. Use a format with no colors
in
the column and then use conditional formatting with 2 conditions - one for
negative numbers and one for positive numbers. (under format puuldown
menu)

hth

DrB said:
Using number format custom to have my numbers come out green or red
depending upon + or - values. The green in [Green0%;Red0%] is too light.
I
want to use dark green, but if I put that in it does not work. Is there a
way to get Dark Green to show up in above formatting?
 
D

Debra Dalgleish

There's a list of the colours in Excel's Help, under 'Number format
codes'. They are:

[Black] [Blue]
[Cyan] [Green]
[Magenta] [Red]
[White] [Yellow]

I tried conditional formatting and decided with number formatting for some
reason some time back with this data. So is there any other choices on
colors with number formatting besides black and red?

If its only for negative vs positive numbers. Use a format with no colors
in
the column and then use conditional formatting with 2 conditions - one for
negative numbers and one for positive numbers. (under format puuldown
menu)

hth

:

Using number format custom to have my numbers come out green or red
depending upon + or - values. The green in [Green0%;Red0%] is too light.
I
want to use dark green, but if I put that in it does not work. Is there a
way to get Dark Green to show up in above formatting?
 
D

DrB

Thank you. Unfortunately they are not dark enough. Is there any alternative
or special modification?

Debra Dalgleish said:
There's a list of the colours in Excel's Help, under 'Number format
codes'. They are:

[Black] [Blue]
[Cyan] [Green]
[Magenta] [Red]
[White] [Yellow]

I tried conditional formatting and decided with number formatting for
some reason some time back with this data. So is there any other choices
on colors with number formatting besides black and red?

If its only for negative vs positive numbers. Use a format with no
colors in
the column and then use conditional formatting with 2 conditions - one
for
negative numbers and one for positive numbers. (under format puuldown
menu)

hth

:


Using number format custom to have my numbers come out green or red
depending upon + or - values. The green in [Green0%;Red0%] is too light.
I
want to use dark green, but if I put that in it does not work. Is there
a
way to get Dark Green to show up in above formatting?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top