| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Format single words in cells
Is it possible to use conditional formatting on individual words inside text
cells,rather than on the whole cells? I have a column filled with quotations where I need a keyword to be highlighted in each cell, not the whole cell... Search & replace too seems to be operating on the formatting of whole cells rather than single keywords. Thanks, Gabriele |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Format single words in cells
No, it is not possible to get conditional formatting to highlight a
single word (of many) in a cell. You would need a macro to do that. Hope this helps. Pete On Nov 17, 2:01*pm, Gabriele wrote: Is it possible to use conditional formatting on individual words inside text cells,rather than on the whole cells? I have a column filled with quotations where I need a keyword to be highlighted in each cell, not the whole cell.... Search & replace too seems to be operating on the formatting of whole cells rather than single keywords. Thanks, Gabriele |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Format single words in cells
THANKS, Gabriele
"Pete_UK" wrote: No, it is not possible to get conditional formatting to highlight a single word (of many) in a cell. You would need a macro to do that. Hope this helps. Pete On Nov 17, 2:01 pm, Gabriele wrote: Is it possible to use conditional formatting on individual words inside text cells,rather than on the whole cells? I have a column filled with quotations where I need a keyword to be highlighted in each cell, not the whole cell.... Search & replace too seems to be operating on the formatting of whole cells rather than single keywords. Thanks, Gabriele . |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Format single words in cells
You're welcome, Gabriele - sorry I couldn't be more positive.
Pete On Nov 17, 4:15*pm, Gabriele wrote: THANKS, Gabriele "Pete_UK" wrote: No, it is not possible to get conditional formatting to highlight a single word (of many) in a cell. You would need a macro to do that. Hope this helps. Pete On Nov 17, 2:01 pm, Gabriele wrote: Is it possible to use conditional formatting on individual words inside text cells,rather than on the whole cells? I have a column filled with quotations where I need a keyword to be highlighted in each cell, not the whole cell.... Search & replace too seems to be operating on the formatting of whole cells rather than single keywords. Thanks, Gabriele .- Hide quoted text - - Show quoted text - |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I highlight a single word or group of words? | Excel Discussion (Misc queries) | |||
| format cells to display 20 long sentences in a single cell | Excel Discussion (Misc queries) | |||
| Separating words in a single cell | Excel Discussion (Misc queries) | |||
| Copy column range of "single word" cells with spaces to a single c | Excel Discussion (Misc queries) | |||
| Format single column cells to be 6 characters long | Excel Worksheet Functions | |||
Linear Mode
