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.