| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
partial word match for conditional formatting
Is it possible to do a partial word match for conditional formatting.
I want to search for any cell that contains the word 'listen' in either upper or lower case and the cell may contain other characters. I tried = *listen* but it didn't work. If possible, I'd also like to change the color of the whole row not just the matching cell in the row. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Find partial match from column A,B and fill partial match in C? | Excel Discussion (Misc queries) | |||
| Conditional Formatting to match cell values | Excel Worksheet Functions | |||
| DSUM Partial Match | Excel Worksheet Functions | |||
| partial lookup/match | Excel Worksheet Functions | |||
| Complicated conditional formatting if numbers match across a data set..How? | Excel Discussion (Misc queries) | |||
Threaded Mode
