| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditionally formatting just part of a cell contents - how?
Hello,
assume my cells ( e.g. A1:E10) are filled with words ( i.e. one word per one cell); I want to find specific character groups, so if I am looking for a group 'eel' and a cells contains 'peeling', I want that "eel" part to get formatted. How could I go about this? In the next step, I would like to obtain the character group to search for from a specific cell, like in - "take the contents of F1 and search for it through A1:E10, if it is found, format that part of a cell contents". Can anyone help? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I conditionally delete rows based on cell contents? | Excel Worksheet Functions | |||
| how can I conditionally format a cell Part 2 | Excel Discussion (Misc queries) | |||
| conditional formatting "if part of cell contents contains string" | Excel Worksheet Functions | |||
| How to conditionally format entire row from contents of one cell? | Excel Discussion (Misc queries) | |||
| Conditionally format one cell for contents of another? | Excel Worksheet Functions | |||
Threaded Mode
