you could use

=OR(ISNUMBER(SEARCH("hotel",A1)),ISNUMBER(SEARCH(" villa",A1)),ISNUMBER(SEARC
H("resort",A1)),ISNUMBER(SEARCH("apartments",A1) ))

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

wrote in message
oups.com...
HI,
what if I want to highlight all the cell that contains hotel, villa,
resort and apartments?
how can i do that?

eg.
Apple hotel
banana hostel
caravan apartment
diana villa

how can i highlight apple hotel, caravan apartment and diana villa
using conditional formatting?


thanks.

SteveG wrote:

This should work. Select the first cell in your range (in my example
A1). Go to Conditional Formatting. Change the CF option from Cell
Value is to Formula is. Enter.

=SEARCH("hotel",A1,1)

FormatPatterns and pick the color you'd like. Click OK. Copy this
format to the rest of your range.

HTH

Steve


--
SteveG
------------------------------------------------------------------------
SteveG's Profile:
http://www.excelforum.com/member.php...fo&userid=7571
View this thread:
http://www.excelforum.com/showthread...hreadid=547883