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

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

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

.

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 -