Conditional format: alternating row colors .....grouping rows with same ID#

[dmj120]

I've tried several variables, and a few similar web searches, and I can't figure this out.

I'm trying to 'group' rows of varying height to alternate between two colors. This is the best so far..... thoughts

 

[kweaver]

Rather than posting an image, please use XL2BB to show your sample data and expected results to that anyone trying to help you doesn't have to retype or try to recreate your information.

 

[kweaver]

Can you get by with a helper column? If so, try something like this which uses a helper column E?

Where column E is the helper and is the following with E2 set to a 1:

Book1
	E
2	1
3	1
4	2
5	2
6	2
7	2
8	3
9	4
10	4
11	4
Sheet4

Cell Formulas
Range	Formula
E3:E11	E3	=IF(A2=A3,E2,E2+1)

 

[Peter_SSs]

Just a small variation on @kweaver's suggestion, also using a helper column (that could be hidden)
I2:I16 all coloured the light blue manually and the Conditional Formatting over-rides that in the relevant rows, so you only need one CF rule.

Conditional Format in Groups.xlsm
	I	J
1	Food	0
2	Cake	1
3	Cake	1
4	Cake	1
5	Cake	1
6	Cake	1
7	Pie	0
8	Pie	0
9	Pie	0
10	Donut	1
11	Donut	1
12	Donut	1
13	Donut	1
14	Donut	1
15	Donut	1
16	Donut	1
Cond Format In Groups

Cell Formulas
Range	Formula
J2:J16	J2	=IF(I2=I1,J1,1-J1)

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
I2:I16	Expression	=$J2	text	YES

 

[Fluff]

Another option

Fluff.xlsm
	A	B	C
1	Code
2	a
3	a
4	a
5	b
6	b
7	b
8	c
9	c
10	d
11	e
12	e
13	f
14
15
16
Main

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
A2:C16	Expression	=AND($A2<>"",MOD(SUMPRODUCT(--($A$2:$A2<>$A$1:$A1)),2))	text	NO

 

[dmj120]

Just a small variation on @kweaver's suggestion, also using a helper column (that could be hidden)
I2:I16 all coloured the light blue manually and the Conditional Formatting over-rides that in the relevant rows, so you only need one CF rule.

Thanks, this works perfectly.

 

[Fluff]

Glad we could help & thanks for the feedback.

 

[Peter_SSs]

Thanks, this works perfectly.

You're welcome. Glad to help.