Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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? |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hi
Highlight the column (say, A) and then try something like this: =NOT(ISERROR(FIND("hotel",A1))) Use the 'Formula is' option. Andy. 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? |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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? |
#4
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]() 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 |
#5
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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? |
#6
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
#7
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
haha i think i know how to do it
just by clicking 'ADD', adding another condition right? :) wrote: 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 |
#8
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
hey what if I have more than 3 conidtions? as it only allows us to
add 3 coniditions..? wrote: haha i think i know how to do it just by clicking 'ADD', adding another condition right? :) wrote: 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 |
#9
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]() That's it but you are limited to 3 CF's. Regards, Steve -- SteveG ------------------------------------------------------------------------ SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571 View this thread: http://www.excelforum.com/showthread...hreadid=547883 |
#10
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]() That's it but you are limited to 3 CF's. Regards, Steve -- SteveG ------------------------------------------------------------------------ SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571 View this thread: http://www.excelforum.com/showthread...hreadid=547883 |
#11
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
thank you very much
SteveG wrote: That's it but you are limited to 3 CF's. Regards, Steve -- SteveG ------------------------------------------------------------------------ SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571 View this thread: http://www.excelforum.com/showthread...hreadid=547883 |
#12
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
conditional formatting for cells containing words | Excel Discussion (Misc queries) | |||
Conditional Formatting when inserting a row | Excel Worksheet Functions | |||
Conditional Formatting | Excel Worksheet Functions | |||
cannot use ISEVEN or ISODD functions in Conditional Formatting | Excel Worksheet Functions | |||
conditional formatting conflict? | Excel Worksheet Functions |