linking format
I would like to link a cell to another cell so that changing the source
cell's formatting (but only the text colour would be fine) would change also the destination cell's format. Something like linking, but not only for values but also for the formats. Does this exist in excel or is there a VBA workaround??? Regards Benny |
linking format
You can't do this kind of thing using formulas.
But you could use a worksheet event that looks for a change to the original cell (value/formula only), then copies that cell and pastes it to that other location. The bad news is that changing the format of that first cell, won't cause this worksheet event to fire. And if that first cell contained a formula, then reevalating the formula won't cause the worksheet_change event to fire, but you could use the worksheet_calculate event. So if this appeals to you, where's that first cell, where's the second cell and how does the first cell change? " wrote: I would like to link a cell to another cell so that changing the source cell's formatting (but only the text colour would be fine) would change also the destination cell's format. Something like linking, but not only for values but also for the formats. Does this exist in excel or is there a VBA workaround??? Regards Benny -- Dave Peterson |
All times are GMT +1. The time now is 02:48 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com