Excel sheets

[Cory]

I am trying to link worksheets in a way that allows a sheet to be auto
updated when I add a comment or format the color of a cell. Is this possible?
So far, only the text gets updated, not the insertion of a comment, nor the
format of cell color. Please help. Thanks

 

[FloMM2]

Cory,
Once you have linked the cell, select the cell, copy.
The linked cell, select cell, edit, paste special, select formats and
comments.
That should do it.
hth