Conditional formatting each next step

[Kishan]

Using Excel 2000</SPAN></SPAN>
Hi,</SPAN></SPAN>

Here the below is my example I need Formula is preferable or an alternative VBA for conditional formatting to highlight each next step pattern in the complete row as per "specific pattern shown in the cells C4, D4 & E4 which is changeable as required" </SPAN></SPAN>

Book1
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R
1
2
3
4			1	1	X
5			P1	P2	P3	P4	P5	P6	P7	P8	P9	P10	P11	P12	P13	P14
6			X	1	1	1	2	1	2	1	2	X	1	1	X	1
7			X	X	2	1	X	X	1	1	2	1	X	2	1	1
8			X	1	1	1	2	1	2	1	2	X	1	1	X	1
9			2	1	1	X	2	1	X	1	1	2	2	1	1	1
10			1	X	1	X	1	1	2	1	1	X	X	X	1	1
11			X	2	X	X	2	X	1	1	2	1	1	1	1	2
12			X	1	1	2	1	1	1	2	1	1	X	1	X	1
13			1	X	X	2	1	X	1	1	1	2	1	1	X	1
14			1	1	1	2	X	X	X	1	X	X	1	X	X	X
15			1	X	X	1	1	1	1	1	X	1	1	2	X	1
16			X	1	X	2	1	2	X	X	X	1	1	1	X	X
17			1	1	X	1	2	1	X	1	1	1	2	1	X	1
18			1	1	1	1	1	X	1	1	1	2	2	X	1	1
19			X	1	1	X	X	1	1	1	1	2	1	1	X	X
20			1	1	1	1	2	1	X	X	1	2	X	1	X	2
21			1	1	1	2	2	1	1	X	1	2	1	1	X	1
22			2	1	X	1	1	X	1	1	1	2	1	1	1	2
23			1	1	1	1	1	2	1	1	2	1	X	X	X	1
24			X	1	1	2	1	1	2	1	1	X	1	1	1	X
25			1	1	1	1	X	1	1	1	1	1	1	1	1	1
26			X	1	1	1	1	2	1	1	X	X	1	1	X	1
27			1	2	X	X	X	X	1	2	1	1	1	X	1	1
28			1	1	1	2	1	2	X	X	X	X	1	X	1	X
29			1	1	1	2	2	1	X	1	X	1	2	1	X	2
30			1	1	1	X	1	1	1	X	1	1	X	1	1	2
31			1	1	1	X	1	1	1	1	1	1	1	1	1	1
32			1	X	1	1	2	1	1	X	X	X	1	X	2	1
33			2	2	1	1	X	1	X	2	1	2	2	1	X	1
34			1	X	1	2	1	1	1	1	1	1	X	1	X	1
35			2	1	1	1	2	X	1	X	X	1	1	X	X	1
36			1	X	X	2	1	1	2	X	1	1	X	1	2	X
37			X	2	X	X	2	X	1	1	2	1	1	1	1	2
38			1	1	1	1	1	2	1	1	2	1	X	X	X	1
39			1	1	1	2	2	1	X	1	X	1	2	1	X	2
40
41
42
43
Sheet5

Thank you in advance</SPAN></SPAN>

Regards,</SPAN>
Kishan</SPAN></SPAN>

 

[Fluff]

Maybe
=OR(AND(C6=$C$4,D6=$D$4,E6=$E$4),AND(B6=$C$4,C6=$D$4,D6=$E$4),AND(A6=$C$4,B6=$D$4,C6=$E$4))

 

[Kishan]

Maybe
=OR(AND(C6=$C$4,D6=$D$4,E6=$E$4),AND(B6=$C$4,C6=$D$4,D6=$E$4),AND(A6=$C$4,B6=$D$4,C6=$E$4))

Fluff, thank you very much for the formula it worked absolutely okay! </SPAN></SPAN>

Kind Regards,</SPAN>
Kishan </SPAN></SPAN>

 

[Fluff]

You're welcome & thanks for the feedback