Setting one cell = to another, formatting included.

[Guest]

I want some cells to change with the source cells, including a change in
formatting (font color, bold, italic, etc.).

A1 = source cell
C1 = copy of source

Setting C1 to =A1 doesn't relay changes in format of A1, or even initial
formatting of A1 that is different from the sheet's standard.

Is there a way to do this? Thanks in advance for any help.

 

[mrice]

You could do this with a macro linked to the worksheet_change even
which performs a copy operation