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

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