A formula, probably quite simple.....

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Insert file and tab name from list into formula 1
Figuring out a lengthy formula. Probably quite simple... 3
Using Dates in Conditional Formatting 9
Help with Formula 5
CONDITIONAL FORMATTING QUERY 0
Help with my Lotto code please 10
returning a text value using a formula 1
IF function to return date content of another cell 7

Back
Top