Conditional formatting based on another cell

	A	B	C	D	E	F	G	H
1	OrderDate	Rep	Item	Units	UnitCost	Total	Region
2	1/6/2016	Wilbur	Pencil	95	1.99	189.05	East
3	1/23/2016	Kivell	Binder	50	19.99	999.5	Central
4	2/9/2016	Joan	Pencil	36	4.99	179.64	Central
5	2/26/2016	Gill	Pen	27	19.99	539.73	Central
6	3/15/2016	Sorvino	Pencil	56	2.99	167.44	West
7	4/1/2016	Joan	Binder	60	4.99	299.4	East
8	4/18/2016	Andrews	Pencil	75	1.99	149.25	Central
9	5/5/2016	Joan	Pencil	90	4.99	449.1	Central
10	5/22/2016	Thompson	Pencil	32	1.99	63.68	West
11	6/8/2016	Wilbur	Binder	60	8.99	539.4	East	Prolific Oaktree - YouTube Channel
12	6/25/2016	Morgan	Pencil	90	4.99	449.1	Central
13	7/12/2016	Howard	Binder	29	1.99	57.71	East
14	7/29/2016	Parent	Binder	81	19.99	1,619.19	East
15	8/15/2016	Wilbur	Pencil	35	4.99	174.65	East
16	9/1/2016	Smith	Desk	2	125	250	Central
17	9/18/2016	Wilbur	Pen Set	16	15.99	255.84	East
18	10/5/2016	Morgan	Binder	28	8.99	251.72	Central
19	10/22/2016	Wilbur	Pen	64	8.99	575.36	East
20	11/8/2016	Parent	Pen	15	19.99	299.85	East
21	11/25/2016	Kivell	Pen Set	96	4.99	479.04	Central
22	12/12/2016	Smith	Pencil	67	1.29	86.43	Central
23	12/29/2016	Parent	Pen Set	74	15.99	1,183.26	East
24	1/15/2017	Gill	Binder	46	8.99	413.54	Central
25	2/1/2017	Smith	Binder	87	15	1,305.00	Central
26	2/18/2017	Wilbur	Binder	4	4.99	19.96	East
27	3/7/2017	Sorvino	Binder	7	19.99	139.93	West
28	3/24/2017	Joan	Pen Set	50	4.99	249.5	Central
29	4/10/2017	Andrews	Pencil	66	1.99	131.34	Central
30	4/27/2017	Howard	Pen	96	4.99	479.04	East
31	5/14/2017	Gill	Pencil	53	1.29	68.37	Central
32	5/31/2017	Gill	Binder	80	8.99	719.2	Central
33	6/17/2017	Kivell	Desk	5	125	625	Central
34	7/4/2017	Wilbur	Pen Set	62	4.99	309.38	East
35	7/21/2017	Morgan	Pen Set	55	12.49	686.95	Central
36	8/7/2017	Kivell	Pen Set	42	23.95	1,005.90	Central
37	8/24/2017	Sorvino	Desk	3	275	825	West
38	9/10/2017	Gill	Pencil	7	1.29	9.03	Central
39	9/27/2017	Sorvino	Pen	76	1.99	151.24	West
40	10/14/2017	Thompson	Binder	57	19.99	1,139.43	West
41	10/31/2017	Andrews	Pencil	14	1.29	18.06	Central
42	11/17/2017	Joan	Binder	11	4.99	54.89	Central
43	12/4/2017	Joan	Binder	94	19.99	1,879.06	Central
44	12/21/2017	Andrews	Binder	28	4.99	139.72	Central
45					44.94
46
47
48
49
50
51
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