Highlight text in word with the same color as the interior color of cell in excel

[nkpan]

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.

[gmayor]

As you have not said what you mean by 'highlighted' in Excel and as you don't appear to know the values of the colours you have applied in Excel, a simple shortcut is to download and install ColorCop which will give you the RGB value and Visual Basic Hex value of any selected colour and you can apply that value to the text in Word.