Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
custom formats
Hi
Is there a way i can turn every instance 0 to the text zero using the custom formats option under format cells? Also is there a way to change the colour of every piece of text in cells. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
custom formats
Is there a way i can turn every instance 0 to the text zero using the
custom formats option under format cells? General;General;"zero" Also is there a way to change the colour of every piece of text in cells. If you mean the color of the entire cell, General;[Red]General;[Blue]"zero" is an example of making negatives red and zeros blue. I know how to make different parts of the text different colors if the cell contains a literal text string constant, but not a formula and not a number. Select a part of the text string and use Format Cells Font Color or an equivalent command button. I have Excel 2003. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
custom formats
thanks so much. this has helped.
"MyVeryOwnSelf" wrote: Is there a way i can turn every instance 0 to the text zero using the custom formats option under format cells? General;General;"zero" Also is there a way to change the colour of every piece of text in cells. If you mean the color of the entire cell, General;[Red]General;[Blue]"zero" is an example of making negatives red and zeros blue. I know how to make different parts of the text different colors if the cell contains a literal text string constant, but not a formula and not a number. Select a part of the text string and use Format Cells Font Color or an equivalent command button. I have Excel 2003. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
custom formats | Excel Discussion (Misc queries) | |||
Custom Formats | Excel Discussion (Misc queries) | |||
Custom Formats | Excel Discussion (Misc queries) | |||
Custom Formats | Excel Discussion (Misc queries) | |||
Custom Formats | Excel Worksheet Functions |