Changing text and colour of a cell linked to another cell [Closed]

Report
Posts
1
Registration date
Tuesday June 23, 2015
Status
Member
Last seen
June 23, 2015
-
Hello,

I understand how to reference a cell to have the same text as another cell in a different worksheet, but how do you also get excel to change the color to be the same?

ie Sheet 1: I change A1 to Red fill and the text ABC
Sheet 2: B1 automatically changes to Red fill with ABC as text

Thanks

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!