A formula, probably quite simple.....

C

confused

Hiya,

Trying to work out a formula, I think it’s probably quite simple however I
can’t quite work it out.

I want to use conditional formatting to turn a cell A1 green if one or more
cells in the range E13:E40 has the value "Yes" or "No" or "Maybe" or
"Undecided".

Can anyone help?

thanks!
 
B

Bob Phillips

=OR(ISNUMBER(MATCH("Yes",$E$13:$E$40,0)),ISNUMBER(MATCH("No",$E$13:$E$40,0))
,ISNUMBER(MATCH("Maybe",$E$13:$E$40,0)))

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)
 
Top