Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Format color - darker green available?
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? |
#2
|
|||
|
|||
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" wrote: 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? |
#3
|
|||
|
|||
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" wrote in message ... 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" wrote: 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? |
#4
|
|||
|
|||
There's a list of the colours in Excel's Help, under 'Number format
codes'. They a [Black] [Blue] [Cyan] [Green] [Magenta] [Red] [White] [Yellow] DrB wrote: 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" wrote in message ... 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" wrote: 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? -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
#5
|
|||
|
|||
Thank you. Unfortunately they are not dark enough. Is there any alternative
or special modification? "Debra Dalgleish" wrote in message ... There's a list of the colours in Excel's Help, under 'Number format codes'. They a [Black] [Blue] [Cyan] [Green] [Magenta] [Red] [White] [Yellow] DrB wrote: 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" wrote in message ... 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" wrote: 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? -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Telephone number format | Excel Discussion (Misc queries) | |||
How do i change numbers in text format to number format? | New Users to Excel | |||
copy conditional format as ACTUAL format | Excel Discussion (Misc queries) | |||
Copying a conditional format | Excel Worksheet Functions | |||
When I select "format cells", the format dialog box does not disp. | Excel Worksheet Functions |