| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Changing Default Color in Custom Number Format
I'd like to use this custom number format: [Green]+0.00;[Red](0.00)
However, the Green displays as Bright Green. How can I change the color given by the [Green] parameter to Green? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Changing Default Color in Custom Number Format
Only eight colors allowed and only one green color available. Conditional formatting may be the approach you need. XL 2007 may be different ? -- Jim Cone Portland, Oregon USA "Diamond Dave" <Diamond wrote in message I'd like to use this custom number format: [Green]+0.00;[Red](0.00) However, the Green displays as Bright Green. How can I change the color given by the [Green] parameter to Green? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Changing Default Color in Custom Number Format
So there isn't a way to change the colors Excel 2003 uses for those eight?
Some way to change what [Green] means? I am already using conditional formatting for something else in these cells. (Besides, this just bugs me.) "Jim Cone" wrote: Only eight colors allowed and only one green color available. Conditional formatting may be the approach you need. XL 2007 may be different ? -- Jim Cone Portland, Oregon USA "Diamond Dave" <Diamond wrote in message I'd like to use this custom number format: [Green]+0.00;[Red](0.00) However, the Green displays as Bright Green. How can I change the color given by the [Green] parameter to Green? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Changing Default Color in Custom Number Format
Try...
Format the font in the cell with the "green" color you prefer. Use this number format... +0.00;[Red](0.00);[Black]0;[Black]General -- Jim Cone Portland, Oregon USA "Diamond Dave" wrote in message So there isn't a way to change the colors Excel 2003 uses for those eight? Some way to change what [Green] means? I am already using conditional formatting for something else in these cells. (Besides, this just bugs me.) "Jim Cone" wrote: Only eight colors allowed and only one green color available. Conditional formatting may be the approach you need. XL 2007 may be different ? -- Jim Cone Portland, Oregon USA "Diamond Dave" <Diamond wrote in message I'd like to use this custom number format: [Green]+0.00;[Red](0.00) However, the Green displays as Bright Green. How can I change the color given by the [Green] parameter to Green? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Changing default color of selected cells in 2007 | Excel Discussion (Misc queries) | |||
| Custom Number Format / Color and Sign | Excel Worksheet Functions | |||
| Changing IN NEW SHEETS the default color of Grid Lines | Excel Discussion (Misc queries) | |||
| Changing the default color of Grid Lines | Excel Discussion (Misc queries) | |||
| How to revert back to default color palatte from custom | Excel Discussion (Misc queries) | |||
Linear Mode
