Exctracting Data

[Brad]

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?

 

[Gord Dibben]

Brad

Only by employing VBA code, in this case a User Defined Function.

See Chip Pearson's site for working with colors.

http://www.cpearson.com/excel/colors.htm


Gord Dibben Excel MVP