conditional formatting on words
wow
thats very helpul, thanks!!
Bob Phillips wrote:
Use a formula of
=ISNUMBER(FIND("hotel"),A1)
--
HTH
Bob Phillips
(replace somewhere in email address with gmail if mailing direct)
wrote in message
ups.com...
how can you do a conditional formatting on a cell that contains words?
ie. I want to highlighted all the cell which contains hotel , such as
happy hotel
holiday inn hotel
hotel hyatt
club hotel resort
(these are all highlighted)
can we do that?
|