shade cell if it equals a word in another cell range

[Guest]

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

 

[Andy Brown]

I would like to have a cell either shade green or red when a certain name
is

placed in a column? Simple

??? ; green for a certain name, red for a certain other name?

Try 2 conditional formatting formulas, such as

=MATCH("Name1",$C:$C,0)

&

=MATCH("Name2",$C:$C,0)

HTH,
Andy

 

[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