$$Excel-Macros$$ Re: Find word in cells and change color of words

2009-05-14 Thread JazzyXXL
Hi Fabio, the problem is, that I do not know the exact position of the word in the cell text. I think the code should be structured like this: 1. search for WORD in cells of column 2 --> text found in cell(x,y) 2. find position of WORD in cell text --> Start = 0 --> Start=instr(Start+1,cell(x

$$Excel-Macros$$ Find word in cells and change color of words

2009-05-13 Thread JazzyXXL
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 speci