PDA

View Full Version : How to connect cells in different sheets in excel


ryan00081
May 9, 2012, 09:26 AM
I can connect data between cells but only the values match. How can I connect cells between different sheets so that if I change the fill color of a cell on sheet 1 it will also change the color on sheet 2?

JBeaucaire
May 9, 2012, 11:48 AM
Manual color choices are not transferable to other cells via formula.

Instead of manually employing color changes, you could create Conditional Formatting rules to change the colors for you based on cell values. Then you could apply those same rules to the other linked cells, thus both cells would change together.