Use Conditional Formatting with Multiple Conditions

	A	B	C	D	E
1	shirt_size	color	quantity	country_code	country
2	L	Pink	16	MG	Madagascar
3	3XL	Aquamarine	14	WS	Samoa
4	2XL	Fuscia	6	GT	Guatemala
5	L	Teal	6	TH	Thailand
6	XS	Purple	8	CN	China
7	2XL	Khaki	14	JP	Japan
8	L	Indigo	11	ID	Indonesia
9	S	Teal	2	FR	France
10	3XL	Crimson	20	BR	Brazil
11	L	Yellow	11	CN	China
12	L	Khaki	19	PE	Peru
13	XL	Goldenrod	17	RU	Russia
14	S	Khaki	17	CN	China
15	S	Teal	3	CN	China
16	S	Mauv	14	RU	Russia
17	XL	Indigo	15	CN	China
18	L	Indigo	14	MX	Mexico
19	M	Violet	1	AR	Argentina
20	XL	Pink	19	PT	Portugal
21	M	Pink	6	PS	Palestinian Territory
22	3XL	Khaki	11	PT	Portugal
23	3XL	Pink	12	BR	Brazil
24	XL	Red	15	CN	China
25	2XL	Maroon	4	PL	Poland
26	L	Green	7	RU	Russia
27	XL	Blue	6	BR	Brazil
28	3XL	Teal	9	AR	Argentina
29	S	Goldenrod	18	PL	Poland
30	M	Yellow	12	JP	Japan
31	XS	Mauv	1	AR	Argentina
32	L	Khaki	19	PH	Philippines
33	XS	Crimson	3	US	United States
34	S	Turquoise	3	RU	Russia
35	XL	Indigo	16	CN	China
36	2XL	Crimson	15	NL	Netherlands
37	XS	Pink	15	PA	Panama
38	M	Blue	11	BR	Brazil
39	2XL	Red	16	SE	Sweden
40	M	Crimson	6	PT	Portugal
41	S	Aquamarine	5	BR	Brazil
42	3XL	Mauv	4	TW	Taiwan
43	2XL	Fuscia	5	KZ	Kazakhstan
44	S	Teal	2	IL	Israel
45	XS	Puce	4	BR	Brazil
46	XS	Blue	18	MN	Mongolia
47	L	Fuscia	8	CG	Republic of the Congo
48	S	Turquoise	12	BJ	Benin
49	3XL	Pink	12	RU	Russia
50	XS	Khaki	11	RU	Russia
51	2XL	Mauv	10	BR	Brazil
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100