Paste link will link the data, not the formatting.


Gord Dibben MS Excel MVP

On Wed, 20 Aug 2008 09:23:01 -0700, Steven
wrote:

I think what you want is a way to ensure that no matter what is in cell A1,
it will also be in another cell.

Use Copy Special, then Paste Link to the new cell.

"Matlock" wrote:

I would like to know of there is a way to copy one cell atributes to another.

Example:

Sheet 1 / A1 = James (Font Red/Bold, Highlighted Yellow)

I want to copy the exact cell with all it's properties to another sheet.

Sheet 2 / A1

Also, when I change the cell. If I change 'James' to 'Bill' or change the
font Color and Face to something else, or Change the Highlighted color; the
corisponding cell will also change to exactly what you changed on the A1 cell.