Spreadsheet: 235041d1368301738-highlight-row-a-certain-color-based-on-a-character-from-a-cell-inventory-tracker
Sheet: Sheet1

RAW PART # | PART | Qty to Ship (Bx) | PCS / BX | Qty (Pcs) | Required For PO | Run Balance | COST |  |  |  | H=YELLOW
200-0105 | 13001C | 0 | 128 |  |  | 0 | 0 | C/O |  |  | M=BLUE
200-0051 | 13001M | 0 | 128 |  |  | 0 | 0 | C/O |  |  | S=GREEN
200-0037 | 13001S | 0 | 128 |  |  | 0 | 0 | C/O |  |  | V=ORANGE
200-0038 | 13001V | 0 | 128 |  |  | 0 | 0 | C/O |  |  | C=PURPLE
200-0052 | 13002M | 0 | 128 |  |  | 0 | 0 | C/O
200-0039 | 13002S | 0 | 128 |  |  | 0 | 0 | C/O
200-0040 | 13002V | 0 | 128 |  |  | 0 | 0 | C/O
200-0104 | 13003C | 0 | 128 |  |  | 0 | 0 | C/O
200-0045 | 13003M | 0 | 128 |  |  | 0 | 0 | C/O
200-0042 | 13003S | 0 | 128 |  |  | 0 | 0 | C/O
200-0041 | 13003V | 0 | 128 |  |  | 0 | 0 | C/O
200-0111 | 13004C | 0 | 128 |  |  | 0 | 0 | C/O
200-0046 | 13004M | 0 | 128 |  |  | 0 | 0 | C/O
200-0044 | 13004S | 0 | 128 |  |  | 0 | 0 | C/O
200-0043 | 13004V | 0 | 128 |  |  | 0 | 0 | C/O
200-0103 | 13008C | 0 | 128 |  |  | 0 | 0 | C/O
200-0094 | 13008M | 0 | 128 |  |  | 0 | 0 | C/O
200-0066 | 13008S | 0 | 128 |  |  | 0 | 0 | C/O
200-0065 | 13008V | 0 | 128 |  |  | 0 | 0 | C/O
200-0126 | 13010C | 0 | 128 |  |  | 0 | 0 | C/O
200-0127 | 13010S | 0 | 128 |  |  | 0 | 0 | C/O
200-0128 | 13010V | 0 | 128 |  |  | 0 | 0 | C/O
200-0131 | 13011C | 0 | 128 |  |  | 0 | 0 | C/O
200-0153 | 13011H | 0 | 128 |  |  | 0 | 0 | C/O
200-0134 | 13011M | 0 | 128 |  |  | 0 | 0 | C/O
200-0132 | 13011S | 0 | 128 |  |  | 0 | 0 | C/O
200-0133 | 13011V | 0 | 128 |  |  | 0 | 0 | C/O
200-0135 | 13012C | 0 | 128 |  |  | 0 | 0 | C/O
200-0138 | 13012M | 0 | 128 |  |  | 0 | 0 | C/O
200-0136 | 13012S | 0 | 128 |  |  | 0 | 0 | C/O
200-0137 | 13012V | 0 | 128 |  |  | 0 | 0 | C/O
200-0139 | 13013C | 0 | 128 |  |  | 0 | 0 | C/O
200-0155 | 13013H | 0 | 128 |  |  | 0 | 0 | C/O
200-0142 | 13013M | 0 | 128 |  |  | 0 | 0 | C/O
200-0140 | 13013S | 0 | 128 |  |  | 0 | 0 | C/O
200-0141 | 13013V | 0 | 128 |  |  | 0 | 0 | C/O
200-0143 | 13014C | 0 | 128 |  |  | 0 | 0 | C/O
200-0146 | 13014M | 0 | 128 |  |  | 0 | 0 | C/O
200-0144 | 13014S | 0 | 128 |  |  | 0 | 0 | C/O
200-0145 | 13014V | 0 | 128 |  |  | 0 | 0 | C/O
200-0064 | 13107M | 0 | 200 |  |  | 0 | 0 | C/O
200-0071 | 13107S | 0 | 200 |  |  | 0 | 0 | C/O
200-0067 | 13107V | 0 | 200 |  | 2600 | -2600 | 0 | C/O
200-0055 | 13108C | 0 | 200 |  |  | 0 | 0 | C/O
200-0092 | 13108M | 0 | 200 |  |  | 0 | 0 | C/O
200-0053 | 13108S | 0 | 200 |  |  | 0 | 0 | C/O
200-0054 | 13108V | 0 | 200 |  |  | 0 | 0 | C/O
200-0077 | 13109C | 0 | 200 |  |  | 0 | 0 | C/O
200-0093 | 13109M | 0 | 200 |  |  | 0 | 0 | C/O
200-0075 | 13109S | 0 | 200 |  |  | 0 | 0 | C/O
200-0076 | 13109V | 0 | 200 |  |  | 0 | 0 | C/O
200-0117 | 13110C | 0 | 200 |  |  | 0 | 0 | C/O
200-0154 | 13110H | 0 | 200 |  |  | 0 | 0 | C/O
200-0150 | 13110M | 0 | 200 |  |  | 0 | 0 | C/O
200-0118 | 13110S | 0 | 200 |  |  | 0 | 0 | C/O
200-0119 | 13110V | 0 | 200 |  |  | 0 | 0 | C/O
200-0147 | 13111C | 0 | 200 |  |  | 0 | 0 | C/O
200-0157 | 13111H | 0 | 200 |  |  | 0 | 0 | C/O
200-0152 | 13111M | 0 | 200 |  |  | 0 | 0 | C/O
200-0148 | 13111S | 0 | 200 |  |  | 0 | 0 | C/O
200-0149 | 13111V | 0 | 200 |  |  | 0 | 0 | C/O
200-0160 | 13112C | 0 | 200 |  |  | 0 | 0 | C/O
200-0123 | 13201C | 0 | 250 |  |  | 0 | 0 | C/O
200-0158 | 13201H | 0 | 250 |  |  | 0 | 0 | C/O
200-0159 | 13201M | 0 | 250 |  |  | 0 | 0 | C/O
200-0124 | 13201S | 0 | 250 |  |  | 0 | 0 | C/O
200-0125 | 13201V | 0 | 250 |  |  | 0 | 0 | C/O
200-0120 | 13202C | 0 | 250 |  |  | 0 | 0 | C/O
200-0156 | 13202H | 0 | 250 |  |  | 0 | 0 | C/O
200-0151 | 13202M | 0 | 250 |  |  | 0 | 0 | C/O
200-0121 | 13202S | 0 | 250 |  |  | 0 | 0 | C/O
200-0122 | 13202V | 0 | 250 |  |  | 0 | 0 | C/O
200-0059 | 13208C | 0 | 250 |  |  | 0 | 0 | C/O
200-0058 | 13208M | 0 | 250 |  |  | 0 | 0 | C/O
200-0056 | 13208S | 0 | 250 |  |  | 0 | 0 | C/O
200-0057 | 13208V | 0 | 250 |  |  | 0 | 0 | C/O
200-0101 | 13209C | 0 | 250 |  |  | 0 | 0 | C/O
200-0091 | 13209M | 0 | 250 |  |  | 0 | 0 | C/O
200-0073 | 13209S | 0 | 250 |  |  | 0 | 0 | C/O
200-0069 | 13209V | 0 | 250 |  |  | 0 | 0 | C/O
200-0072 | 13307S | 0 | 250 |  |  | 0 | 0 | C/O
200-0068 | 13307V | 0 | 250 |  |  | 0 | 0 | C/O
200-0062 | 13308C | 0 | 250 |  |  | 0 | 0 | C/O
200-0063 | 13308M | 0 | 250 |  |  | 0 | 0 | C/O
200-0060 | 13308S | 0 | 250 |  |  | 0 | 0 | C/O
200-0061 | 13308V | 0 | 250 |  |  | 0 | 0 | C/O
200-0102 | 13309C | 0 | 250 |  |  | 0 | 0 | C/O
200-0090 | 13309M | 0 | 250 |  |  | 0 | 0 | C/O
200-0074 | 13309S | 0 | 250 |  |  | 0 | 0 | C/O
200-0070 | 13309V | 0 | 250 |  |  | 0 | 0 | C/O
200-0006 | 14001H | 0 | 128 |  |  | 0 | 0 | C/O
200-0001 | 14001M | 0 | 128 |  |  | 0 | 0 | C/O
200-0003 | 14001S | 0 | 128 |  |  | 0 | 0 | C/O
200-0022 | 14001V | 0 | 128 |  |  | 0 | 0 | C/O
200-0005 | 14002H | 0 | 128 |  |  | 0 | 0 | C/O
200-0002 | 14002M | 0 | 128 |  |  | 0 | 0 | C/O
200-0004 | 14002S | 0 | 128 |  |  | 0 | 0 | C/O
200-0023 | 14002V | 0 | 128 |  |  | 0 | 0 | C/O
200-0008 | 14003H | 0 | 128 |  |  | 0 | 0 | C/O
200-0012 | 14003M | 0 | 128 |  |  | 0 | 0 | C/O
200-0007 | 14003S | 0 | 128 |  |  | 0 | 0 | C/O
200-0024 | 14003V | 0 | 128 |  |  | 0 | 0 | C/O
200-0010 | 14004H | 0 | 128 |  |  | 0 | 0 | C/O
200-0011 | 14004M | 0 | 128 |  |  | 0 | 0 | C/O
200-0009 | 14004S | 0 | 128 |  |  | 0 | 0 | C/O
200-0025 | 14004V | 0 | 128 |  |  | 0 | 0 | C/O
200-0106 | 14005C | 0 | 128 |  |  | 0 | 0 | C/O
200-0029 | 14005H | 0 | 128 |  |  | 0 | 0 | C/O
200-0030 | 14005M | 0 | 128 |  |  | 0 | 0 | C/O
200-0031 | 14005S | 0 | 128 |  |  | 0 | 0 | C/O
200-0032 | 14005V | 0 | 128 |  |  | 0 | 0 | C/O
200-0112 | 14006C | 0 | 128 |  |  | 0 | 0 | C/O
200-0033 | 14006H | 0 | 128 |  |  | 0 | 0 | C/O
200-0034 | 14006M | 0 | 128 |  |  | 0 | 0 | C/O
200-0035 | 14006S | 0 | 128 |  |  | 0 | 0 | C/O
200-0036 | 14006V | 0 | 128 |  |  | 0 | 0 | C/O
200-0113 | 14007C | 0 | 128 |  |  | 0 | 0 | C/O
200-0050 | 14007H | 0 | 128 |  |  | 0 | 0 | C/O
200-0049 | 14007M | 0 | 128 |  |  | 0 | 0 | C/O
200-0047 | 14007S | 0 | 128 |  |  | 0 | 0 | C/O
200-0048 | 14007V | 0 | 128 |  |  | 0 | 0 | C/O
200-0109 | 14010M | 0 | 128 |  |  | 0 | 0 | C/O
200-0108 | 14010S | 0 | 128 |  |  | 0 | 0 | C/O
200-0107 | 14010V | 0 | 128 |  |  | 0 | 0 | C/O
200-0110 | 14013H | 0 | 128 |  |  | 0 | 0 | C/O
200-0098 | 14013M | 0 | 128 |  |  | 0 | 0 | C/O
200-0099 | 14013S | 0 | 128 |  |  | 0 | 0 | C/O
200-0100 | 14013V | 0 | 128 |  |  | 0 | 0 | C/O
200-0114 | 14014C | 0 | 128 |  |  | 0 | 0 | C/O
200-0130 | 14014H | 0 | 128 |  |  | 0 | 0 | C/O
200-0129 | 14014M | 0 | 128 |  |  | 0 | 0 | C/O
200-0115 | 14014S | 0 | 128 |  |  | 0 | 0 | C/O
200-0116 | 14014V | 0 | 128 |  |  | 0 | 0 | C/O
200-0017 | 14101H | 0 | 54 |  |  | 0 | 0 | C/O
200-0013 | 14101M | 0 | 54 |  |  | 0 | 0 | C/O
200-0015 | 14101S | 0 | 54 |  |  | 0 | 0 | C/O
200-0026 | 14101V | 0 | 54 |  |  | 0 | 0 | C/O
200-0018 | 14102H | 0 | 54 |  |  | 0 | 0 | C/O
200-0014 | 14102M | 0 | 54 |  |  | 0 | 0 | C/O
200-0016 | 14102S | 0 | 54 |  |  | 0 | 0 | C/O
200-0027 | 14102V | 0 | 54 |  |  | 0 | 0 | C/O
200-0021 | 14103H | 0 | 54 |  |  | 0 | 0 | C/O
200-0020 | 14103M | 0 | 54 |  |  | 0 | 0 | C/O
200-0019 | 14103S | 0 | 54 |  |  | 0 | 0 | C/O
200-0028 | 14103V | 0 | 54 |  |  | 0 | 0 | C/O
200-0080 | 14111M | 0 | 54 |  |  | 0 | 0 | C/O
200-0079 | 14111S | 0 | 54 |  |  | 0 | 0 | C/O
200-0078 | 14111V | 0 | 54 |  |  | 0 | 0 | C/O
200-0083 | 14112M | 0 | 54 |  |  | 0 | 0 | C/O
200-0082 | 14112S | 0 | 54 |  |  | 0 | 0 | C/O
200-0081 | 14112V | 0 | 54 |  |  | 0 | 0 | C/O
200-0086 | 14113M | 0 | 54 |  |  | 0 | 0 | C/O
200-0085 | 14113S | 0 | 54 |  |  | 0 | 0 | C/O
200-0084 | 14113V | 0 | 54 |  |  | 0 | 0 | C/O
200-0089 | 14117M | 0 | 54 |  |  | 0 | 0 | C/O
200-0088 | 14117S | 0 | 54 |  |  | 0 | 0 | C/O
200-0087 | 14117V | 0 | 54 |  |  | 0 | 0 | C/O
200-0161 |  |  |  |  |  | 0 |  | C/O
200-0162 |  |  |  |  |  | 0 |  | C/O
200-0163 |  |  |  |  |  | 0 |  | C/O
200-0164 |  |  |  |  |  | 0 |  | C/O
 |  |  |  |  |  |  | 0 | C/O
 |  |  |  |  |  |  |  | C/O
 |  |  |  |  |  |  |  | C/O
 |  |  |  |  |  |  |  | C/O
 |  |  |  |  |  |  |  | C/O
 |  |  |  |  |  |  |  | C/O
 |  |  |  |  |  |  |  | C/O
 |  |  |  |  |  |  |  | C/O
 |  |  |  |  |  |  |  | C/O
 |  |  |  |  |  |  |  | C/O
 |  |  |  |  |  |  |  | C/O
 |  |  |  |  |  |  |  | C/O
 |  |  |  |  |  |  |  | C/O
 |  |  |  |  |  |  |  | C/O
 |  |  |  |  |  |  |  | C/O
 |  |  |  |  |  |  |  | C/O
 |  |  |  |  |  |  |  | C/O
 |  |  |  |  |  |  |  | C/O
 |  |  |  |  |  |  |  | C/O
 |  |  |  |  |  |  |  | C/O
 |  |  |  |  |  |  |  | C/O
 |  |  |  |  |  |  |  | C/O
 |  |  |  |  |  |  |  | C/O
 |  |  |  |  |  |  |  | C/O
 |  |  |  |  |  |  |  | C/O
 |  |  |  |  |  |  |  | C/O
 |  |  |  |  |  |  |  | C/O
 |  |  |  |  |  |  |  | C/O
 |  |  |  |  |  |  |  | C/O
 |  |  |  |  |  |  |  | C/O
 |  |  |  |  |  |  |  | C/O
 |  |  |  |  |  |  |  | C/O
 |  |  |  |  |  |  |  | C/O
 |  |  |  |  |  |  |  | C/O