Vlookup question

[AG]

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?

 

[T. Valko]

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

 

[Pete_UK]

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