Conditional formatting as per group pattern

[Kishan]

Conditional formatting as per group pattern </SPAN></SPAN>

Using Excel 2000</SPAN></SPAN>

Hi,</SPAN></SPAN>

I need conditional formatting as per groups PATTERNS</SPAN></SPAN>
Group-1 pattern "1|1" interior colour RED & font colour white</SPAN></SPAN>
Group-2 pattern "1|X", "1|2", "X|1", "2|1" interior colour GREEN & font colour white</SPAN></SPAN>
Group-3 pattern "X|X", "X|2", "2|X", "2|2" interior colour BLUE & font colour white</SPAN></SPAN>

Result data example</SPAN></SPAN>

Book1
	A	B	C	D
1
2
3
4
5			Patterns
6			1|1
7			1|1
8			1|X
9			X|2
10			1|1
11			1|1
12			1|1
13			1|2
14			1|2
15			X|X
16			X|X
17			X|X
18			X|1
19			X|1
20			X|1
21			2|2
22			1|1
23			1|1
24			2|2
25			2|2
26			X|X
27			X|X
28			X|X
29			2|2
30			2|2
31			1|1
32			2|2
33			2|2
34			2|1
35			2|1
36			2|X
37			2|X
38			2|2
39			2|X
40
41
Sheet1

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

Regards,</SPAN>
Kishan</SPAN>

 

[Kishan]

</SPAN>Sorry, I observed that cell C6 & C7 also should be colures Red & white</SPAN></SPAN>
Here is the corrected example

Book1
	A	B	C	D
1
2
3
4
5			Patterns
6			1|1
7			1|1
8			1|X
9			X|2
10			1|1
11			1|1
12			1|1
13			1|2
14			1|2
15			X|X
16			X|X
17			X|X
18			X|1
19			X|1
20			X|1
21			2|2
22			1|1
23			1|1
24			2|2
25			2|2
26			X|X
27			X|X
28			X|X
29			2|2
30			2|2
31			1|1
32			2|2
33			2|2
34			2|1
35			2|1
36			2|X
37			2|X
38			2|2
39			2|X
40
41
Sheet1

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


</SPAN></SPAN>

 

[Fluff]

For the first one use
=C6="1|1"
for the next use
=OR(C6="1|X", C6="1|2",C6="X|1",C6="2|1")
And modify this for the 3rd

 

[Kishan]

For the first one use
=C6="1|1"
for the next use
=OR(C6="1|X", C6="1|2",C6="X|1",C6="2|1")
And modify this for the 3rd

Hi Fluff, it worked as request, 100% Prefect!! </SPAN></SPAN>

Thank you for your help</SPAN></SPAN>

Have a nice day</SPAN></SPAN>

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

 

[Fluff]

Glad to help & thanks for the feedback