how to highlight the results of a search string in a worksheet?

R

Raju

Hi,

I am trying to search for a particualr string in a sheet/set of columns. If
a cell contains the search string, i want only the search string to be
highlighted and not the entire cell. how can i get this done?

Please Advice
 
P

Pete_UK

You couldn't do this with a formula or conditional formatting - you
would need a macro.

Pete
 

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

Top