Special conditional formatting; highlight the series

[Kishan]

Using Excel 2000</SPAN></SPAN>

Hi,</SPAN></SPAN>

I am looking special conditional formatting; perhaps it would not be possible doing by the formula. Need your help with a VBA solution </SPAN></SPAN>

My series is made of three characters 1, X and 2</SPAN></SPAN>

I want to highlight every series in 2 different colours as shown in the given example below</SPAN></SPAN>

Here is a example of row 6, and will be followed the same method for all the rest rows bellows, Series start with "1" and will end with "2"</SPAN></SPAN>

C6 = X its alone series end, because D6 has "1" so highlight C6 with Green</SPAN></SPAN>
D6 = 1 and E6 = 2 series end, because F6 has "1" so highlight D6:E6 with Red</SPAN></SPAN>
F6:G6 Series with colour Green</SPAN></SPAN>
H6:I6 series with colour Red</SPAN></SPAN>
J6:L6 series with colour Green</SPAN></SPAN>
And last M6:P6 with colour Red </SPAN></SPAN>

Result data example</SPAN></SPAN>

Book1
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q
1
2
3
4
5			P1	P2	P3	P4	P5	P6	P7	P8	P9	P10	P11	P12	P13	P14
6			X	1	2	1	2	X	X	1	1	2	1	X	2	2
7			1	X	2	2	2	1	X	X	2	2	X	X	1	1
8			1	X	1	1	X	X	2	2	X	X	1	1	X	X
9			1	X	1	2	2	1	X	1	1	X	1	2	2	1
10			X	1	X	1	X	1	1	X	1	1	1	X	X	1
11			X	X	X	1	1	1	1	X	1	X	2	1	2	X
12			2	X	1	1	1	2	X	X	X	1	1	1	2	1
13			X	1	X	X	1	1	1	1	1	1	1	X	1	1
14			2	1	1	X	2	1	1	X	2	X	2	2	2	X
15			X	1	1	2	X	1	2	1	1	1	1	1	1	X
16			1	2	1	2	X	2	1	X	1	2	X	1	1	1
17			2	X	X	1	2	2	1	1	1	2	1	1	1	X
18			1	1	1	1	2	1	1	1	2	1	2	1	X	X
19			1	2	1	2	1	1	1	2	2	1	2	1	1	X
20
21
Sheet2

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

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

 

[nikio8]

Re: Need help with a special conditional formatting; highlight the series

PS, I only now see that you wanted to evaluate pairs of data XX X1 11 X2 12 22, not 1111XXX2222 XXX as per my assumption. Good practice.