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