I need help with this...please!

Easiest way to explain this is...I have 40,000 lines of data that I
need to look at. To make the data more readable for review, I want to
seperate unique accounts with shading (i.e. records for account 1 are
not shaded, records for account 2 are shaded, records for account 3 are
not shaded,............etc).

Please see attached excel file. Sheet 1 is raw data. Sheet 2 is the
desired result.

I am thinking I can create a macro or use some type of conditional
formatting to create the desired result.

Thanks in advance for any comments.


+-------------------------------------------------------------------+
|Filename: shading_example.ZIP |
|Download: http://www.excelforum.com/attachment.php?postid=3699 |
+-------------------------------------------------------------------+

--
mcnenny
------------------------------------------------------------------------
mcnenny's Profile: http://www.excelforum.com/member.php...o&userid=26383
View this thread: http://www.excelforum.com/showthread...hreadid=396619