Autofomrat Group of rows with same cell value

[sanketgroup]

Hi

Column A contains account numbers, and other columns contains some transactions related to account.

30552-1 GARCIA, NORMA 8/18/2011 20550
30552-1 GARCIA, NORMA 8/18/2011 J1040
30552-1 GARCIA, NORMA 8/18/2011 J2010
47365-1 HARDEN, BOWDY 2/8/2011 99213
47365-1 HARDEN, BOWDY 2/8/2011 73110
24240-1 HENRY, PAUL G 8/30/2011 97110
24240-1 HENRY, PAUL G 8/30/2011 97140
48247-1 HILL, RITA A 8/19/2011 99244
4798-1 HUSSETT, DEVON L 8/30/2011 97110
4798-1 HUSSETT, DEVON L 8/30/2011 97140
4798-1 HUSSETT, DEVON L 8/16/2011 97110

I want macro to select group with same account number and then format it with alternate colors band and border.

I have attached screen shot as well excel sheet
screen shot link
\1

[watersev]

hi sanketgroup, option, press Run button or run code "test"

[sanketgroup]

Hi watersev,
thanks for quick reply.
it almost working. Only, border is not being done properly.
at the end, It just make border to first row of each group.
following is the screen shot.
\1
photo sharing sites

[watersev]

I do not see any difference between result output and desired result of yours in the posted file sample