Conditional cell color

I have created a calendar within Excel and would like to accomplish the
following:

Whenever I enter text (any text) into a cell, I would like for the cell
background to change to the color RED. Whenever the cell is empty, I would
like for it to remain a default color of GREEN.

Is this possible? If so, how do I accomplish this?

Thanks in advance!

You will need to make two conditions within the Conditional Format box and
have both set to "Formula Is". Then place the following in its appropriate
box next to FORMULA IS:

1) =AND(A1="") Format to GREEN
2) =AND(A1"") Format to RED

Obviously adjust the cell reference as needed.

Les

"Brent" wrote:

I have created a calendar within Excel and would like to accomplish the
following:

Whenever I enter text (any text) into a cell, I would like for the cell
background to change to the color RED. Whenever the cell is empty, I would
like for it to remain a default color of GREEN.

Is this possible? If so, how do I accomplish this?

Thanks in advance!

format desired cells as green
then formatconditionalformatleft window select formula
is=istext(a2)format as desired
use format painter to copy
--
Don Guillett
SalesAid Software

"Brent" wrote in message
...
I have created a calendar within Excel and would like to accomplish the
following:

Whenever I enter text (any text) into a cell, I would like for the cell
background to change to the color RED. Whenever the cell is empty, I
would
like for it to remain a default color of GREEN.

Is this possible? If so, how do I accomplish this?

Thanks in advance!

Hi Brent

Set you default colour as Green.
Then, Mark the range of cells you require FormatConditional Formatting
select Formula is from dropdown
=ISTEXT(A1)
FormatFill colourRed

where A1 represents the first cell in the range you have marked

--
Regards

Roger Govier


"Brent" wrote in message
...
I have created a calendar within Excel and would like to accomplish the
following:

Whenever I enter text (any text) into a cell, I would like for the
cell
background to change to the color RED. Whenever the cell is empty, I
would
like for it to remain a default color of GREEN.

Is this possible? If so, how do I accomplish this?

Thanks in advance!

This seems to work for the GREEN condition, however when I test this by
inserting text into a cell range, ALL conditioned cells switch to white -
even the cells where I have not entered text.

I double checked the formatting I made in the Conditional Format box, and
everything is color coded properly (font & background), in terms of my
desired outcome.

"WLMPilot" wrote:

You will need to make two conditions within the Conditional Format box and
have both set to "Formula Is". Then place the following in its appropriate
box next to FORMULA IS:

1) =AND(A1="") Format to GREEN
2) =AND(A1"") Format to RED

Obviously adjust the cell reference as needed.

Les

"Brent" wrote:

I have created a calendar within Excel and would like to accomplish the
following:

Whenever I enter text (any text) into a cell, I would like for the cell
background to change to the color RED. Whenever the cell is empty, I would
like for it to remain a default color of GREEN.

Is this possible? If so, how do I accomplish this?

Thanks in advance!

Don / Roger -

thank you! Your suggestions seemed to be what I was looking for. I sensed
there was a term/phrase I was needing to complete th elogic - in this case it
was 'ISTEXT'.

Regards!


"Roger Govier" wrote:

Hi Brent

Set you default colour as Green.
Then, Mark the range of cells you require FormatConditional Formatting
select Formula is from dropdown
=ISTEXT(A1)
FormatFill colourRed

where A1 represents the first cell in the range you have marked

--
Regards

Roger Govier


"Brent" wrote in message
...
I have created a calendar within Excel and would like to accomplish the
following:

Whenever I enter text (any text) into a cell, I would like for the
cell
background to change to the color RED. Whenever the cell is empty, I
would
like for it to remain a default color of GREEN.

Is this possible? If so, how do I accomplish this?

Thanks in advance!

glad to help

--
Don Guillett
SalesAid Software

"Brent" wrote in message
...
Don / Roger -

thank you! Your suggestions seemed to be what I was looking for. I
sensed
there was a term/phrase I was needing to complete th elogic - in this case
it
was 'ISTEXT'.

Regards!


"Roger Govier" wrote:

Hi Brent

Set you default colour as Green.
Then, Mark the range of cells you require FormatConditional Formatting
select Formula is from dropdown
=ISTEXT(A1)
FormatFill colourRed

where A1 represents the first cell in the range you have marked

--
Regards

Roger Govier


"Brent" wrote in message
...
I have created a calendar within Excel and would like to accomplish the
following:

Whenever I enter text (any text) into a cell, I would like for the
cell
background to change to the color RED. Whenever the cell is empty, I
would
like for it to remain a default color of GREEN.

Is this possible? If so, how do I accomplish this?

Thanks in advance!

Format, conditional formatting is where you want to be. Highlight the entire column you want this to affect. If cell is equal to "Yes" then...here you choose how you want your text and background to look. You can have up to 3 conditions.

EggHeadCafe.com - .NET Developer Portal of Choice
http://www.eggheadcafe.com