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
HIS


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