Inventory list with highlighting.xlsx

	B	C	D	E	F	G	H	I	J	K	L
1
2	Inventory list
3	Patheros Labs
4								Highlight items to reorder?			Yes
5	For reorder	Inventory ID	Name	Description	Unit price	Quantity in stock	Inventory value	Reorder level	Reorder time in days	Quantity in reorder	Discontinued?
6	1	IN0001	Item 1	Desc 1	$51.00	25	$1,275	29	13	50
7	1	IN0002	Item 2	Desc 2	$93.00	132	$12,276	231	4	50
8	0	IN0003	Item 3	Desc 3	$57.00	151	$8,607	114	11	150
9	0	IN0004	Item 4	Desc 4	$19.00	186	$3,534	158	6	50
10	0	IN0005	Item 5	Desc 5	$75.00	62	$4,650	39	12	50
11	1	IN0006	Item 6	Desc 6	$11.00	5	$55	9	13	150
12	0	IN0007	Item 7	Desc 7	$56.00	58	$3,248	109	7	100	Yes
13	1	IN0008	Item 8	Desc 8	$38.00	101	$3,838	162	3	100
14	0	IN0009	Item 9	Desc 9	$59.00	122	$7,198	82	3	150
15	1	IN0010	Item 10	Desc 10	$50.00	175	$8,750	283	8	150
16	1	IN0011	Item 11	Desc 11	$59.00	176	$10,384	229	1	100
17	1	IN0012	Item 12	Desc 12	$18.00	22	$396	36	12	50
18	1	IN0013	Item 13	Desc 13	$26.00	72	$1,872	102	9	100
19	1	IN0014	Item 14	Desc 14	$42.00	62	$2,604	83	2	100
20	0	IN0015	Item 15	Desc 15	$32.00	46	$1,472	23	15	50
21	1	IN0016	Item 16	Desc 16	$90.00	96	$8,640	180	3	50
22	0	IN0017	Item 17	Desc 17	$97.00	57	$5,529	98	12	50	Yes
23	1	IN0018	Item 18	Desc 18	$12.00	6	$72	7	13	50
24	1	IN0019	Item 19	Desc 19	$82.00	143	$11,726	164	12	150
25	0	IN0020	Item 20	Desc 20	$16.00	124	$1,984	113	14	50
26	0	IN0021	Item 21	Desc 21	$19.00	112	$2,128	75	11	50
27	0	IN0022	Item 22	Desc 22	$24.00	182	$4,368	132	15	150
28	0	IN0023	Item 23	Desc 23	$29.00	106	$3,074	142	1	150	Yes
29	0	IN0024	Item 24	Desc 24	$75.00	173	$12,975	127	9	100
30	0	IN0025	Item 25	Desc 25	$14.00	28	$392	21	8	50
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
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