Setting one cell = to another, formatting included.
 

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.

Setting one cell = to another, formatting included.
 

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


--
mrice

Research Scientist with many years of spreadsheet development experience
------------------------------------------------------------------------
mrice's Profile: http://www.excelforum.com/member.php...o&userid=10931
View this thread: http://www.excelforum.com/showthread...hreadid=539354