Hiya,

Trying to work out a formula, I think its probably quite simple however I
cant 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!

=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)

"confused" wrote in message
...
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!