View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Pete_UK Pete_UK is offline
external usenet poster
 
Posts: 8,856
Default how to highlight the results of a search string in a worksheet?

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

Pete

On Oct 22, 10:52*am, Raju wrote:
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