Hi, following problem is causing me sleepless nights: I have got a table containing a list of patents. I would like to search for specific terms/words in the abstracts of the patents and to mark them by changing their color. I do not want to change the color of the whole cell containing the specific word. I tried to record a macro but that does not seem to be possible. At least Excel does not want to.
Can somebody help me in writing a macro for that purpose? Thanks, Luca Table looks like this search for: WORD Nr. Title Abstract Author .... 1 blabla blubblub WORD blub blub sdfsdf 2 blublu blabbla WORD bla bla bla werwer 3 blibli blimblum blae WORD blimblam jhgkhjk ... --~--~---------~--~----~------------~-------~--~----~ ------------------------------------------------------------------------------------- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com ------------------------------------------------------------------------------------- -~----------~----~----~----~------~----~------~--~---
