CF, macro require

[Kishan]

Using Excel 2000
Hi,

VBA, conditional formatting macro in the columns C, D & E as shown colours for pattern in the C1:E4 and in the columns G, H & I as shown colours for pattern in the G3:I3

Example data

Book1
	A	B	C	D	E	F	G	H	I	J	K
1			1|1	1|X	X|X		1|1	X|1	2|1
2				1|2	X|2		1|X	X|X	2|X
3				X|1	2|X		1|2	X|2	2|2
4				2|1	2|2
5			P1	P2	P3		P1	P2	P3
6			X|1	1|1	2|1		X|1	1|1	2|1
7			X|X	2|1	X|X		X|X	2|1	X|X
8			X|1	1|1	2|1		X|1	1|1	2|1
9			2|1	1|X	2|1		2|1	1|X	2|1
10			1|X	1|X	1|1		1|X	1|X	1|1
11			X|2	X|X	2|X		X|2	X|X	2|X
12			X|1	1|2	1|1		X|1	1|2	1|1
13			1|X	X|2	1|X		1|X	X|2	1|X
14			1|1	1|2	X|X		1|1	1|2	X|X
15			1|X	X|1	1|1		1|X	X|1	1|1
16			X|1	X|2	1|2		X|1	X|2	1|2
17			1|1	X|1	2|1		1|1	X|1	2|1
18			1|1	1|1	1|X		1|1	1|1	1|X
19			X|1	1|X	X|1		X|1	1|X	X|1
20			1|1	1|1	2|1		1|1	1|1	2|1
21			1|1	1|2	2|1		1|1	1|2	2|1
22			2|1	X|1	1|X		2|1	X|1	1|X
23			1|1	1|1	1|2		1|1	1|1	1|2
24			X|1	1|2	1|1		X|1	1|2	1|1
25			1|1	1|1	X|1		1|1	1|1	X|1
26			X|1	1|1	1|2		X|1	1|1	1|2
27			1|2	X|X	X|X		1|2	X|X	X|X
28			1|1	1|2	1|2		1|1	1|2	1|2
29			1|1	1|2	2|1		1|1	1|2	2|1
30			1|1	1|X	1|1		1|1	1|X	1|1
31			1|1	1|X	1|1		1|1	1|X	1|1
32			1|X	1|1	2|1		1|X	1|1	2|1
33			2|2	1|1	X|1		2|2	1|1	X|1
34			1|X	1|2	1|1		1|X	1|2	1|1
35			2|1	1|1	2|X		2|1	1|1	2|X
36			1|X	X|2	1|1		1|X	X|2	1|1
37			X|1	1|1	1|1		X|1	1|1	1|1
38			X|2	1|1	X|X		X|2	1|1	X|X
39			X|1	2|1	2|1		X|1	2|1	2|1
40			1|1	1|X	X|1		1|1	1|X	X|1
41			2|X	1|1	1|1		2|X	1|1	1|1
42			X|2	X|1	1|1		X|2	X|1	1|1
43
44
45
46
Sheet1

Thank you in advance

Regards,
Kishan

 

[Kishan]

Okay, how about this then....

Hi Rick, it is exactly the same as a post#9</SPAN></SPAN>

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

 

[Rick Rothstein]

Hi Rick, it is exactly the same as a post#9</SPAN></SPAN>

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

Okay, then I do not have a more compact nor faster macro that I can offer you... use the one KolGuyXcel gave you which you modified and says works for you. We need to convince you to move up to a newer version of Excel... there is so much extra functionality and minimal limitations available in XL2010 and later.