Format single words in cells

[Gabriele]

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

 

[Pete_UK]

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

 

[Gabriele]

THANKS, Gabriele

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



.

 

[Pete_UK]

You're welcome, Gabriele - sorry I couldn't be more positive.

Pete