conditional format if cell contains the text IQ anywhere in cell
 

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

conditional format if cell contains the text IQ anywhere in cell
 

Formula is

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


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



--
Regards,

Peo Sjoblom





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

conditional format if cell contains the text IQ anywhere in ce
 

thanks Peo, works great.

"Peo Sjoblom" wrote:

Formula is

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


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



--
Regards,

Peo Sjoblom





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

conditional format if cell contains the text IQ anywhere in ce
 

Thanks for the feedback


--
Regards,

Peo Sjoblom



"SteveC" wrote in message
...
thanks Peo, works great.

"Peo Sjoblom" wrote:

Formula is

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


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



--
Regards,

Peo Sjoblom





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