How to link a cell format with another cell?

[Merbman]

I have not found this topic yet ! I would like to link a cell with another cell. Not only the value, but also the format. How can I link the format of a cell to another cell? The result will be a changed cell when I have changed the source cell. Thanx !

--------------------------------------------------------------------------------

 

[Mudface]

You could copy the cell you've linked to then Paste Special- Formats onto your destination cell. But, unless it's a conditional format, then changes to the format of the linked cell aren't updated automatically to the destination cell. Sorry I can't be of more help .

 

[Merbman]

thanx for the information. I think we have something Excel can work on !!