Cell Reference for the Color of a cell?

[texcel]

Hello to all you beautiful Excel users hope you are grand!

Reason I write today is this:

Is it possible to create a Cell Reference to another Cell so tha
information such as the Border of the Cell Border OR the Color of i
will transfer to another Cell?

For instance:

Cell A2 is red and has an underline border and I would like to create
reference that makes D4 red and with an underline without having to us
the tool bar. Then if I change A2 to green D4 will turn green.

Please respond.
Thanks

Ti

 

[Dave Peterson]

You can't do this kind of thing with a formula.

But you could use a macro and some worksheet event. But you'd have to be pretty
specific with what cell controls what cell (and formatting changes don't fire
events--you'd could be one calculation behind being the same.)

I think I'd just use a macro that copies|pastes special formats for each cell
combination. And run it whenever I wanted (right before closing the
workbook???).