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