Format single words in cells

G

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
 
P

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
 
G

Gabriele

THANKS, Gabriele

Pete_UK said:
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



.
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Conditional Formatting ignoring cells with a format already 2
Automatic Highlighting of Cells 4
count colored cells in excel 5
Conditional formatting by key words 4
Function Help - Forecast Date past due, adjacent cell is blank. Needto highlight the blank cell. 2
Function to concatenate cells in a range 3
Using NULL in shading cells 1
format cells from data range 1

Top