I'm using simple links as well as Vlookups to retreive data from another
workbook. However, I need to not only retreive the cell content I need to
copy the source cell format, i.e. shading, text coloring, etc. I can't use
manual format pasting as the format in the source cell can change at anytime
based on other users' input.

Is this possible (and how) with standard Excel worksheet functions to do
this (i.e. without using something like a macro/VBA)?

Any help would be greatly appreciated.

Thanks