Pete,
How would i go about writing this Macro? Would I do it on the sheet tab
under "view code"? Or would it be under Tool - Macros - Record New Macros?
Please help.

"Pete_UK" wrote:

A function can only return a result - it cannot bring the format from
another cell.

Yes, a macro could do this.

Hope this helps.

Pete