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