shade cell if it equals a word in another cell range

[Everet]

I would like to have a cell either shade green or red when a certain name is
placed in a column? Simple

 

[Frank Kabel]

Hi
have a look at 'Format - Conditional Format. See:
http://www.cpearson.com/excel/cformatting.htm

 

[Andrew P]

use conditional format from format drop down - select cell
value and equals to - type the word you want select the
font and away you go.


Thanks


Andrew