I have a worksheet that one of my sales people set up to track the materials
for a job they are doing. They have seperated the various stages by
highlighting the lines with different colors (ie: blue for prewire, yellow
for rough in, and white for final stage). I want to track these on seperate
tabs but I want to have my tabs linked in case he makes changes to his
original sheet. Is there any way to add a formula that will pick up the
different colors?