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.