View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Pete_UK Pete_UK is offline
external usenet poster
 
Posts: 8,856
Default 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