I am trying to set up a link that enables the data to come up gray IF a blank
cell above it is gray, THEN I would like that data to be linked over to
another sheet in the gray rims row. The problem I'm having is that some of
this data will be gray and some will be black, depending on what color rims
were ran that day. Is this possible in Excel? EG.... One day ED Paint may
run Black rims and the next it may run Silver Rims. I am inputting this data
in a spreadsheet. I then have another spreadsheet w/ a chart on it that's
picking up the black and/or silver info for that day. Do you understand
this?