conditional formatting challenge

[mark gardner]

I have a list of names and scores arranged in rows. I used conditional formatting and the MOD formula to color every other row, and keep them in alternating bands of color even if I delete or add a row. But, now I have 2 rows per person with the odd number rows being hidden. My formula to color every other row doesn't work anymore because when hide the odd numberes rows, all of the remaining rows are the same color. Can someone help me with this.

Excel Workbook
	A	B	C	D	E	F	G	H
10	Johnson	27	54	76	54	76
11		h	u	r	b	b
12	Echols	86	43	28	68	21
13		b	u	b	u	r
14	Miller	76	67	23	21	59
15		r	b	r	r	r
16	Singletary	54	87	56	14	55
17		u	u	r	u	b
Sheet3

 

[lenze]

From Chip Pearson
http://www.cpearson.com/Excel/banding.aspx

=MOD(ROW()-Rw,N*2)+1<=N

Where Rw is the 1st row of your data and N = number of rows in each band
lenze