conditional format if cell contains the text IQ anywhere in cell

[SteveC]

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...

 

[Peo Sjoblom]

Formula is

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


=ISNUMBER(FIND("IQ",A1)) (case sensitive will only find IQ)

 

[SteveC]

thanks Peo, works great.

Formula is

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


=ISNUMBER(FIND("IQ",A1)) (case sensitive will only find IQ)

 

[Peo Sjoblom]

Thanks for the feedback