I tend to use conditional formatting for this - to keep it truely
dynamic. Or write a piece of VBA as the overhead is lower.

You can either do the testing as a formula in the conditional
formatting or create a new colum using a formula such as
=IF(A2=A1,B1,NOT(B1)) (the new column is B) this alternates between
TRUE and FALSE for each GROUP. Then it is a simple matter to set the
conditional formatting to use white for TRUE and Grey for False or
whatever. The formatting can be applier to each affected column.

hope this helps


--
tony h
------------------------------------------------------------------------
tony h's Profile: http://www.excelforum.com/member.php...o&userid=21074
View this thread: http://www.excelforum.com/showthread...hreadid=490729