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