| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
conditional formatting on words
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
|
|||
|
|||
|
conditional formatting on words
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
|
|||
|
|||
|
conditional formatting on words
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
|
|||
|
|||
|
conditional formatting on words
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
|
|||
|
|||
|
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? |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
conditional formatting on words
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
|
|||
|
|||
|
conditional formatting on words
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
|
|||
|
|||
|
conditional formatting on words
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
|
|||
|
|||
|
conditional formatting on words
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
|
|||
|
|||
|
conditional formatting on words
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
|
|||
|
|||
|
conditional formatting on words
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
|
|||
|
|||
|
conditional formatting on words
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 | |
|
|
Similar Threads
|
||||
| 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 | |||
Linear Mode
