VBA Required to enable vlookup to copy the font colour

[Mr___D]

Hi,

fingers crossed you can help. When I use the vlookup formula I'd like the colour of the font as well as the cell content to be returned in the result.

I believe VBA code is required for this, can anyone help?

vba font vlookup

 

[Fluff]

Hi & welcome to MrExcel.
Have a look here How to vlookup and return background color along with the lookup value in Excel?

 

[Mr___D]

Hi & welcome to MrExcel.
Have a look here How to vlookup and return background color along with the lookup value in Excel?

Thanks for the quick reply (and the welcome )
I successfully implemented the VBA you referred to to copy the cell colour (a task I did a month or so ago) but I can't find the equivalent code for the font colour. I imagine it'll be similar but unfortunately I'm clueless

Andrew

 

[Fluff]

Just change each instance of Interior.Color to Font.Color