I sort of get it but not quite enough to give an intelligent answer. If
you'd like, you can send the master and summary sheets (or a piece from
each) and I'll take a look at it. You should be able to use a formula
in the summary sheet to maintain the colored cell regardless, but
without a clearer picture of the different parameters, it's a little
hard to do without seeing it.




--
wmjenner


------------------------------------------------------------------------
wmjenner's Profile: http://www.excelforum.com/member.php...fo&userid=5282
View this thread: http://www.excelforum.com/showthread...hreadid=394243