Copy Cell atributes to another

[Matlock]

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.

 

[Gary''s Student]

Use Edit Copy / Paste

This will copy the cell with all attributes. But if you later change the
formatting of the source cell, you will have to re-copy.

 

[Steven]

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.

 

[Gord Dibben]

Paste link will link the data, not the formatting.


Gord Dibben MS Excel MVP