A formula, probably quite simple.....

[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!

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

"confused" <[email protected]> wrote in message
news:[email protected]...
> 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!
>