How do I keep the font color with VLOOKUP?

[Joboozy]

I reference data from another workbook but the font color will not transfer,
only the value. How can I get both?

 

[Nick Hodge]

Simply...no. Functions only return values, although if the colours signify
criteria then look up conditional formatting in help

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
[email protected]