How to link a cell format with another cell?

Merbman · Mar 4th, 2002, 10:07 AM

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 · Mar 4th, 2002, 11:08 AM

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 · Mar 4th, 2002, 11:18 AM

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

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 4th, 2002, 10:07 AM	#1
Merbman New Member Join Date: Mar 2002 Posts: 4	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 ! --------------------------------------------------------------------------------

Mar 4th, 2002, 11:08 AM	#2
Mudface MrExcel MVP Join Date: Feb 2002 Location: Sunny, spring-like Hull Posts: 3,339	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 .

Mar 4th, 2002, 11:18 AM	#3
Merbman New Member Join Date: Mar 2002 Posts: 4	thanx for the information. I think we have something Excel can work on !!