Hi
not possible with formulas/user defined functions as they can only
return values

--
Regards
Frank Kabel
Frankfurt, Germany

"WintonCW" schrieb im Newsbeitrag
...
I am copying data from one sheet to another. I have used the
=VLOOKUP () to find the data which is working nicely. However, is
there any way to copy the formatting of the entire cell that I've found
(ie -- background color)? I'm guessing I"ll have to write my own
macro, so any help on this would be greatly appreciated. Thank you!