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>
Thank you in advance</SPAN></SPAN>
Regards,</SPAN>
Kishan</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>
Last edited: