How to keep a mirror image of a cell in another cell

[tassmazahir]

Hi,
I want to know if it is possible to keep a mirror copy of one cell in another cell. Assume I have cell A1, and I want a exact copy of it in cell A2 (font, color, etc.), and everytime I change anything in cell A1, it should refresh the contents, fonts etc. in cell A2.
Any assistance will be appreciated. Thanks.

 

[PaddyD]

see if the camera does what you want:

right click on a tool bar, go to customise. select the 'commands' tab & select 'tools' - scrol down & find the camera option. drag it to a menu bar. then select a cell, click the camera icon & select a destination for the 'picture' of the cell...change the formatting etc on the source cell to see what you get.

Paddy