Thread: Text Highlight
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Paul Mak Paul Mak is offline
external usenet poster
 
Posts: 4
Default Text Highlight

I have an Excel file with over 25,000 row of records in 12 columns. I need
to find and highlight the matching keywords in 3 of the columns. The
keywords is listed in a seperate workbook in the same Excel file. How do I
loop throught all the keywords and highlight the matching one on the other
workbook? I want only the matching keyword highlight but not the entire
cell. The same keyword could occour in more than one instance in the content
of a cell. Thanks a million.