Conditional cell color

B

Brent

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!
 
W

WLMPilot

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
 
D

Don Guillett

format desired cells as green>
then format>conditionalformat>left window select formula
is>=istext(a2)>format as desired
use format painter to copy
 
R

Roger Govier

Hi Brent

Set you default colour as Green.
Then, Mark the range of cells you require Format>Conditional Formatting>
select Formula is from dropdown
=ISTEXT(A1)
Format>Fill colour>Red

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

Brent

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.
 
B

Brent

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!
 
S

steelbee

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
 
Top