Not really. Maybe conditional formatting but that's very limited to the
types of formatting available and would not be dynamic if you change the
formatting of the source cell.

--
Biff
Microsoft Excel MVP


"Jim" wrote in message
...
Ok, thanks. I thought it might be so easy I was being stupid. good to
know
i'm not! :-)

Any smart workarounds that you can think of?


--
Best Regards
Jim


"T. Valko" wrote:

Is this possible?

Unfortunately, no. A formula returns only the value.


--
Biff
Microsoft Excel MVP


"Jim" wrote in message
...
Hi

When using simple ="cell reference" (eg =c2) Excel should copy the cell
value AND the cell format.

Is this possible?

Thanks
--
Best Regards
Jim