![]() |
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? |
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? |
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? |
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? |
All times are GMT +1. The time now is 11:39 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com