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

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

Well ...

If the font colour was applied through some conditional formatting
formula (like date is before today), then the same conditional
formatting criteria could apply to the cell with the vlookup formula
in and match the colour that way.

Hope this helps.

Pete

On May 14, 10:26*pm, "T. Valko" wrote:
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- Hide quoted text -

- Show quoted text -