HI all,

I hope someone can help me come up with code that will conditionally format
a summary sheet(scorecard) based on the conditional formats in another
workbook. I used Excel driven conditional formatting in my main data sheet
which works great, but the problem is with the final scorecard.

The summary is really a scorecard and only needs color indicators. So when
I sell products in a country each product has allowable market targets.(high
and low). The conditional formatting is easy to do in the database
worksheet. The requirements of the scorecard are such that if any one
product is red in the database, the metric in the scorecard is flagged with
red , if there are no reds but there is a yellow, it flags yellow, etc.

Any ideas would be very appreciated.