Hi,

as a beginer I need to ask for help with this macro:

I have column in EXCEL - each cell is populated with data (or some are empty). I also have a long document in WORD.
I need a macro that would go through each cell in EXCEL column, copy data, and than made all data which it founds in WORD document RED - so it stands out and I can easily spot it in document.

and I also need macro to skip blank cells in EXCEL.


Picture shows the result I want to achieve:
RED excel word.jpg

Thank for any advice.