Exctracting Data
 

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?

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

On Thu, 20 Jan 2005 05:51:05 -0800, "Brad"
wrote:

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?