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]HIS


"Joboozy" <[email protected]> wrote in message
news:[email protected]...
>I reference data from another workbook but the font color will not
>transfer,
> only the value. How can I get both?