Day5 Conditional Formating.xlsx

	A	B	C	D	E	F	G	H	I	J
1	AreaCode	ProductType	Product	State	Territory	Target_Product	Actual_Profit	Market_Price
2	1001	Ground	Coffee	California	West	350	400	150	Green	> 300
3	1002	Beans	Tea	New York	East	350	250	200	Light Red	< 301
4	1003	Instant	Coffee	Texas	South	200	500	250	Yellow	280 -310
5	1004	Ground	Latte	Florida	South	300	550	180	Between	300-500
6	1005	Beans	Coffee	Washington	West	100	300	210
7	1006	Instant	Cappuccino	Illinois	Midwest	302	100	230
8	1007	Ground	Colombian	Arizona	West	310	300	170
9	1008	Beans	Americano	Ohio	Midwest	100	100	260
10	1009	Instant	Macchiato	Georgia	South	340	150	220
11	1010	Ground	Irish Coffee	North Carolina	South	280	400	190
12	1011	Beans	Tea	Michigan	Midwest	360	100	300
13	1012	Instant	Espresso	New Jersey	East	500	500	240
14	1013	Ground	Coffee	Virginia	South	250	260	310
15	1014	Beans	Latte	Massachusetts	East	310	280	150
16	1015	Instant	Mocha	Indiana	Midwest	260	390	270
17	1016	Ground	Cappuccino	Tennessee	South	400	100	200
18	1017	Beans	Colombian	Missouri	Midwest	270	500	160
19	1018	Instant	Americano	Arizona	West	230	100	280
20	1019	Ground	Macchiato	Wisconsin	Midwest	340	125	300
21	1020	Beans	Irish Coffee	Minnesota	Midwest	290	420	190
22	1021	Instant	Coffee	Colorado	West	260	100	250
23	1022	Ground	Tea	Alabama	South	240	350	140
24	1023	Beans	Espresso	South Carolina	South	220	330	270
25	1024	Instant	Latte	Mississippi	South	290	290	180
26	1025	Ground	Mocha	Kentucky	South	300	280	230
27	1026	Beans	Cappuccino	Arkansas	South	350	499	260
28	1027	Instant	Colombian	Oklahoma	South	310	430	210
29	1028	Ground	Americano	Iowa	Midwest	290	400	170
30	1029	Beans	Macchiato	Connecticut	East	320	450	200
31	1030	Instant	Irish Coffee	Oregon	West	280	200	190
32	1031	Ground	Coffee	Kansas	Midwest	270	100	160
33	1032	Beans	Tea	Utah	West	260	350	140
34	1033	Instant	Espresso	Nebraska	Midwest	250	330	150
35	1034	Ground	Latte	New Mexico	West	290	152	230
36	1035	Beans	Mocha	Nevada	West	300	190	200
37	1036	Instant	Cappuccino	West Virginia	South	280	370	210
38	1037	Ground	Colombian	Idaho	West	310	450	190
39	1038	Beans	Americano	Hawaii	West	330	470	250
40	1039	Instant	Macchiato	Montana	West	240	350	180
41	1040	Ground	Irish Coffee	South Dakota	Midwest	320	450	170
42	1041	Beans	Coffee	North Dakota	Midwest	270	380	200
43	1042	Instant	Tea	Alaska	West	250	340	210
44	1043	Ground	Espresso	Vermont	East	280	390	220
45	1044	Beans	Latte	Wyoming	West	290	400	230
46	1045	Instant	Mocha	Delaware	East	240	350	160
47	1046	Ground	Cappuccino	New Hampshire	East	300	410	270
48	1047	Beans	Colombian	Maine	East	310	200	180
49	1048	Instant	Americano	Rhode Island	East	260	250	210
50	1049	Ground	Macchiato	Montana	West	290	410	250
51	1050	Beans	Irish Coffee	South Dakota	Midwest	280	390	190
52	1051	Instant	Coffee	North Dakota	Midwest	300	420	170
53	1052	Ground	Tea	Alaska	West	310	290	150
54	1053	Beans	Espresso	Vermont	East	250	360	240
55	1054	Instant	Latte	Wyoming	West	270	254	230
56	1055	Ground	Mocha	Delaware	East	320	440	210
57	1056	Beans	Cappuccino	New Hampshire	East	240	350	190
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