No. A formula can only return the value to its cell. It can't "pull" the
formatting with it.

--
Biff
Microsoft Excel MVP


"AG" wrote in message
...
When using Vlookup to copy dates from one excel file to another, is there
a
way to copy the font color of the date to the new sheet while still using
the
Vlookup function?
--
Alan