Conditionally format rows based on unique column value

[JansiJansi]

Hi there. I'd like to alternate highlighting on rows depending on the value in column A. If the value in column A is the same for multiple rows, the rows highlight one color. As soon as it's different, it alternates. Here's a visual example:

Could someone help with a conditional format formula?

Thank you!

 

[SanjayGMusafir]

Can we add a helper column?

 

[JansiJansi]

Can we add a helper column?

We can - when I look around at other resources it all mentions this but I don't understand it 100%. Is it basically a control for the CF to work off of?

 

[SanjayGMusafir]

Check this and revert - Here Column C is a Helper Column

Book1
	A	B	C
1	XYZ	Any Value	1
2	XYZ	Any Value	1
3	XYZ	Any Value	1
4	XYZ	Any Value	1
5	ABC	Any Value	2
6	ABC	Any Value	2
7	ABC	Any Value	2
8	ABC	Any Value	2
9	XYZ	Any Value	3
10	XYZ	Any Value	3
11	XYZ	Any Value	3
12	XYZ	Any Value	3
13	ABC	Any Value	4
14	ABC	Any Value	4
15	ABC	Any Value	4
16	ABC	Any Value	4
Sheet2

Cell Formulas
Range	Formula
C2:C16	C2	=IF(A2=A1,C1,C1+1)

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
A1:C16	Expression	=ISEVEN($C1)	text	NO
A1:C16	Expression	=ISODD($C1)	text	NO

 

[JansiJansi]

This works perfectly and is much easier to understand than other resources thank you Sanjay

 

[SanjayGMusafir]

Glad to help you and thanks for the feedback.