Is it possible to make changes to one excel sheet and have the other excel sheet display the same changes?

by on October 7, 2012

Q: How do I link formatting in an Excel document? I have two sheets within an excel document. The data is linked between the two sheets. That data is identical except that sheet 1 is alphabetized and sheet two is in a random order. But I would like to link the formatting for the cells as well. If I change the color of a cell in sheet two, I want it to automatically match the corresponding cell in sheet 1 that it’s data is already linked to.