Hello All,
I am working on a macro where i have a highlighted excel cell with colors like Green, Pink, Blue Red.
My macro searches each excel value in a word document and highlight the found word with the same color as it is in excel.
I have tired for example vbGreeb and wdGreen but both are different colors.
Could you please help me on how to deal with such cases.
Thank you.