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.