Conditional formtting with text

[Richard Rosell]

I am using Excel Office 2003

Problem:

I am setting up a template that includes conditional formatting. I would
like the color of the cell to change to red, for example, when it contains
text and green if it is empty. Unfortunately, the text placed in a
particular cell may vary (names of various college courses) from one
instance to another. Is there a formula that will turn the cell red when it
contains text and green when it does not.

Thanks for any suggestion you might offer.

Richard

 

[El Gordo]

I am using Excel Office 2003

Problem:

I am setting up a template that includes conditional formatting. I would
like the color of the cell to change to red, for example, when it contains
text and green if it is empty. Unfortunately, the text placed in a
particular cell may vary (names of various college courses) from one
instance to another. Is there a formula that will turn the cell red when
it contains text and green when it does not.

Thanks for any suggestion you might offer.

Richard

Richard,
You can accomplish this by selecting all of the cells you would like to
behave this way and format them to have green shading. Then go to
'conditional formatting' in the 'format' menu. If you choose 'cell value is'
and then 'greater than' and put 0 in as the condition, then when anything is
entered into one of these cells (besides 0), then the cell will change to
red from green. When the value is deleted, it will revert to green. Hope
this helps,

J