| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
conditional formatting -- testing for multiple words
I have a spreadsheet with a list of products. Column D contains the
product names. I want to format the rows to stand out if a particular word is in the product name. I've got this to work: =FIND("Chef",$D1) What I'd really like to do is have the formula look for a variety of different products; e.g., "Chef", "Apple", "Lodge" ... etc. Is there any way to do that?? Thanks. Barb |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional Formatting in Bar Charts with Labeling | Charts and Charting in Excel | |||
| conditional formatting for cells containing words | Excel Discussion (Misc queries) | |||
| enhanced conditional formatting | Excel Discussion (Misc queries) | |||
| Copying conditional formatting...HELP PLEASE!!!! | Excel Worksheet Functions | |||
| conditional formatting question | Excel Discussion (Misc queries) | |||
Threaded Mode
