Excel 2003 change cell colour based on text?

[styley]

Is there a handy way to change a cell colour based on the text entered into the cell. For example if "Yes" is typed into the cell it will turn green and if "No" is entered into a cell it will turn red?

[HowardKennitby]

Look up 'Conditional Formatting'

[MarkRae]

http://www.timeatlas....ing_to_highlight_data

[Old_Geezer]

Format/Conditional Formatting, as HK says.
You can set up cell value is equal to "Yes" and then set the format to have a pattern, font, and border as required. Then a second condition for "No".

[styley]

Thanks, got that working now. But is there a way to allow for the word to be either "Yes" or "yes" and "No" or "no"?

[styley]

Actually, I know what to do now. Thanks for the help guys.

[styley]

Aargh!! No I don't. I thought that I could just add in two more conditions to allow for it but it would only let me do one. Does anyone know how to phrase it so that it allows for either "Yes" or "yes" or "No" or "no"?

[HowardKennitby]

you may be able to include the 'UPPER' function as part of the condition. I haven't tried anything this complex.

[HowardKennitby]

^
obviously the condition check will then be YES or NO

[SeaJayPea]

Do you mean that you want one colour if it's YES and another colour if it's yes?

Otherwise, it's working for both for me.

[Old_Geezer]

I think you'd need to define 4 conditions.

[Old_Geezer]

And since it is 3 maximum you've a problem.

Maybe you can highlight a cell in a different column by setting it using a nested if statement referring to the yes/no cell. Not quite what you want but it is a work around maybe.

[styley]

SeaJay was right, it worked regardless of upper or lower case. Don't know why it didn't work correctly the first time but it is working correctly now. Thanks for all the responses.