Creating a Link Between Two Cells

[sdruley]

I have two cells on one worksheet that are in random locations. One cell is named A and the other is named B. How do I get the color of cell A to be the same as cell B? Cell A is currently red but cell B is green. How do I get cell A to be green without using vba?

 

[Fluff]

How/why was cell B coloured?

 

[sdruley]

How/why was cell B coloured?

It has to do with developing a measurement system when two objects change their relativity to one another. If the measurement system works it will demonstrate how time is bent to accommodate a zero residual between a future event and current time. It is a way to make future objects appear in the now time independent of how far they are in the future. Sorry to add confusion to my simple question.

 

[shg]

Format painter?

 

[sdruley]

Format painter?

Thank you shg for providing an answer as simple as the question

 

[shg]

You're welcome.