Conditional Format Every Other Group of Rows

[mnyankee]

In the screenshot below, you can see that every other group of rows is highlighted based on the EID column. This is a small example that I did manually to show what is needed to be done on a 20k row sheet. I have not been able to come up with a formula to use in the conditional formatting. Any help or suggestions will be greatly appreciated.

 

[PeteWright]

Will you accept a small helper column as solution?

Book1.xlsm
	A	B	C
1	Agent #	EID	0
2	12345	22331	1
3	23456	22331	1
4	34567	22331	1
5	45678	44566	2
6	56789	44566	2
7	67890	66788	3
8	78901	88977	4
9	89012	88977	4
10	90123	88977	4
Sheet25

Cell Formulas
Range	Formula
C2:C10	C2	= IF(B1<>B2,C1+1,C1)

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
A2:B10	Expression	= ISEVEN($C2)	text	NO
A2:B10	Expression	= ISODD($C2)	text	NO

 

[mnyankee]

Will you accept a small helper column as solution?

Book1.xlsm
	A	B	C
1	Agent #	EID	0
2	12345	22331	1
3	23456	22331	1
4	34567	22331	1
5	45678	44566	2
6	56789	44566	2
7	67890	66788	3
8	78901	88977	4
9	89012	88977	4
10	90123	88977	4
Sheet25

Cell Formulas
Range	Formula
C2:C10	C2	= IF(B1<>B2,C1+1,C1)

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
A2:B10	Expression	= ISEVEN($C2)	text	NO
A2:B10	Expression	= ISODD($C2)	text	NO

I may have to accept a helper column even though I was trying to avoid it because it may confuse the end users. Thanks, I appreciate your feedback.

 

[Fluff]

Another option

Fluff.xlsm
	A	B
1	Agent #	EID
2	12345	22331
3	23456	22331
4	34567	22331
5	45678	44566
6	56789	44566
7	67890	66788
8	78901	88977
9	89012	88977
10	90123	88977
11
12
Master

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
A2:B12	Expression	=AND($B2<>"",ISODD(ROWS(UNIQUE($B$2:$B2))))	text	NO

 

[mnyankee]

Another option

Fluff.xlsm
	A	B
1	Agent #	EID
2	12345	22331
3	23456	22331
4	34567	22331
5	45678	44566
6	56789	44566
7	67890	66788
8	78901	88977
9	89012	88977
10	90123	88977
11
12
Master

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
A2:B12	Expression	=AND($B2<>"",ISODD(ROWS(UNIQUE($B$2:$B2))))	text	NO

Works great, thank you!

 

[Fluff]

Glad we could help & thanks for the feedback.