conditional formatting on words

[elaine216]

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?

 

[Guest]

Hi

Highlight the column (say, A) and then try something like this:
=NOT(ISERROR(FIND("hotel",A1)))
Use the 'Formula is' option.

Andy.

 

[Bob Phillips]

Use a formula of

=ISNUMBER(FIND("hotel"),A1)

--
HTH

Bob Phillips

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

 

[SteveG]

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

=SEARCH("hotel",A1,1)

Format>Patterns and pick the color you'd like. Click OK. Copy thi
format to the rest of your range.

HTH

Stev

 

[elaine216]

wow
thats very helpul, thanks!!

Use a formula of

=ISNUMBER(FIND("hotel"),A1)

--
HTH

Bob Phillips

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

 

[elaine216]

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.

 

[elaine216]

haha i think i know how to do it
just by clicking 'ADD', adding another condition right?

 

[elaine216]

hey what if I have more than 3 conidtions? as it only allows us to
add 3 coniditions..?

 

[SteveG]

That's it but you are limited to 3 CF's.

Regards,
Steve

 

[SteveG]

That's it but you are limited to 3 CF's.

Regards,
Steve

 

[elaine216]

thank you very much

 

[Bob Phillips]

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)

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.