Spreadsheet: 680888d1591239105-conditional-formatting-based-on-other-cells-test-sheet_cf
Sheet: Sheet1

 | RECEIVED ITEMS |  | 2020-06-01 00:00:00
 |  | ITEM |  |  |  |  |  | PURCHASE |  |  |  |  | [NAME] |  | STOCK INVENTORY
 | ITEM NO. | [NAME] | DATE ORDERED | DATE/TIME  RECEIVED | QUANTITY ORDERED | QUANTITY RECEIVED | QUANTITY REMAINING | VENDOR | PO # | WORK ORDER CONTRACT NUMBER | STOCK | VENDOR  ORDER NO. | AREA | SHELF / BIN | QTY | ITEM AREA | ITEM SHELF / BIN
 | X7930 | HC14-23 Cab | 2020-05-29 00:00:00 | 2020-06-01 09:00:00 | 1 | 1 |  | Company L | 29586 | 154133 | YES | abc1 | Residential | O-2
 | X0585 | HC-11 | 2020-05-29 00:00:00 | 2020-06-01 09:00:00 | 1 | 1 |  | Company L | 29586 | 154133 | YES | abc2 | Residential | O-2
 | MPG 25141 | MPG 2514 | 2020-05-27 00:00:00 | 2020-06-01 11:20:00 | 5 | 5 |  | K Supply | 29571 |  | yes | xyz1 |  |  | 5 | Hardware
 | MPG 25106 | MPG 2510 | 2020-05-27 00:00:00 | 2020-06-01 11:20:00 | 4 | 4 |  | K Supply | 29571 | 66766 | yes | xyz2 |  |  | 4 | Hardware
 |  |  |  |  |  |  |  |  |  |  | yes
 |  |  |  |  |  |  |  |  |  |  | yes
 |  |  |  |  |  |  |  |  |  |  | yes
 |  |  |  |  |  |  |  |  |  |  | yes
 |  |  |  |  |  |  |  |  |  |  | yes
 |  |  |  |  |  |  |  |  |  |  | yes
 |  |  |  |  |  |  |  |  |  |  | yes
 |  |  |  |  |  |  |  |  |  |  | yes
 |  |  |  |  |  |  |  |  |  |  | yes
 |  |  |  |  |  |  |  |  |  |  | yes
 |  |  |  |  |  |  |  |  |  |  | yes
 |  |  |  |  |  |  |  |  |  |  | yes
 |  |  |  |  |  |  |  |  |  |  | yes
 |  |  |  |  |  |  |  |  |  |  | yes
 |  |  |  |  |  |  |  |  |  |  | yes
 |  |  |  |  |  |  |  |  |  |  | yes
 |  |  |  |  |  |  |  |  |  |  | yes
 |  |  |  |  |  |  |  |  |  |  | yes
 |  |  |  |  |  |  |  |  |  |  | yes
 |  |  |  |  |  |  |  |  |  |  | yes
 |  |  |  |  |  |  |  |  |  |  | yes
 |  |  |  |  |  |  |  |  |  |  | yes
 |  |  |  |  |  |  |  |  |  |  | yes
 |  |  |  |  |  |  |  |  |  |  | yes
 |  |  |  |  |  |  |  |  |  |  | yes
 |  |  |  |  |  |  |  |  |  |  | yes
 |  |  |  |  |  |  |  |  |  |  | yes
 |  |  |  |  |  |  |  |  |  |  | yes
 |  |  |  |  |  |  |  |  |  |  | yes
 |  |  |  |  |  |  |  |  |  |  | yes
 |  |  |  |  |  |  |  |  |  |  | yes
 |  |  |  |  |  |  |  |  |  |  | yes
 |  |  |  |  |  |  |  |  |  |  | yes
 |  |  |  |  |  |  |  |  |  |  | yes
 |  |  |  |  |  |  |  |  |  |  | yes
 |  |  |  |  |  |  |  |  |  |  | yes
 |  |  |  |  |  |  |  |  |  |  | yes
 |  |  |  |  |  |  |  |  |  |  | yes
 |  |  |  |  |  |  |  |  |  |  | yes
 |  |  |  |  |  |  |  |  |  |  | yes
 |  |  |  |  |  |  |  |  |  |  | yes
 |  |  |  |  |  |  |  |  |  |  | yes
 |  |  |  |  |  |  |  |  |  |  | yes
 |  |  |  |  |  |  |  |  |  |  | yes
 |  |  |  |  |  |  |  |  |  |  | yes
 |  |  |  |  |  |  |  |  |  |  | yes
 |  |  |  |  |  |  |  |  |  |  | yes
 |  |  |  |  |  |  |  |  |  |  | yes
 |  |  |  |  |  |  |  |  |  |  | yes
 |  |  |  |  |  |  |  |  |  |  | yes
 |  |  |  |  |  |  |  |  |  |  | yes
 |  |  |  |  |  |  |  |  |  |  | yes
 |  |  |  |  |  |  |  |  |  |  | yes
 |  |  |  |  |  |  |  |  |  |  | yes
 |  |  |  |  |  |  |  |  |  |  | yes
 |  |  |  |  |  |  |  |  |  |  | yes
 |  |  |  |  |  |  |  |  |  |  | yes
 |  |  |  |  |  |  |  |  |  |  | yes
 |  |  |  |  |  |  |  |  |  |  | yes
 |  |  |  |  |  |  |  |  |  |  | yes
 |  |  |  |  |  |  |  |  |  |  | yes
 |  |  |  |  |  |  |  |  |  |  | yes
 |  |  |  |  |  |  |  |  |  |  | yes
 |  |  |  |  |  |  |  |  |  |  | yes
 |  |  |  |  |  |  |  |  |  |  | yes
 |  |  |  |  |  |  |  |  |  |  | yes
 |  |  |  |  |  |  |  |  |  |  | yes
 |  |  |  |  |  |  |  |  |  |  | yes
 |  |  |  |  |  |  |  |  |  |  | yes
 |  |  |  |  |  |  |  |  |  |  | yes
 |  |  |  |  |  |  |  |  |  |  | yes
 |  |  |  |  |  |  |  |  |  |  | yes
 |  |  |  |  |  |  |  |  |  |  | yes
 |  |  |  |  |  |  |  |  |  |  | yes
 |  |  |  |  |  |  |  |  |  |  | yes
 |  |  |  |  |  |  |  |  |  |  | yes
 |  |  |  |  |  |  |  |  |  |  | yes
 |  |  |  |  |  |  |  |  |  |  | yes
 |  |  |  |  |  |  |  |  |  |  | yes
 |  |  |  |  |  |  |  |  |  |  | yes
 |  |  |  |  |  |  |  |  |  |  | yes
 |  |  |  |  |  |  |  |  |  |  | yes
 |  |  |  |  |  |  |  |  |  |  | yes
 |  |  |  |  |  |  |  |  |  |  | yes
 |  |  |  |  |  |  |  |  |  |  | yes