conditional format if cell contains the text IQ anywhere in cell

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

Guest

I did a search, couldn't find an answer:

How do I use conditonal formatting if say, cell A1 contains the text "IQ"
(not equals IQ)

thanks...
 
Formula is

=ISNUMBER(SEARCH("IQ",A1)) (will find both IQ and iq)


=ISNUMBER(FIND("IQ",A1)) (case sensitive will only find IQ)
 
thanks Peo, works great.

Peo Sjoblom said:
Formula is

=ISNUMBER(SEARCH("IQ",A1)) (will find both IQ and iq)


=ISNUMBER(FIND("IQ",A1)) (case sensitive will only find IQ)
Click to expand...
 
Back
Top