Spreadsheet: 679624d1590525491-conditional-formatting-in-a-table-so-sheet-forum-post
Sheet: Special Order Sheet

BVSD Special Order Verification |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Hedging
SO # | Order Date | Customer Name | Pamp | Eagle | Krug | Maple | 1/2 | 1/4 | 5g | Eagles | Maples | Krugs | Rounds | 10oz | 100oz | Price | Total | Earliest Release Date | Shelf | Phone | Source / [Hedge] | Invoice # |  | Gold | Silver
466 | 2020-05-18 00:00:00 | Customer 1 |  |  |  |  |  |  |  | 1000 |  |  |  |  |  | 21.02 |  | 2020-05-18 00:00:00 | 1 | Monday.com | Ordered
527 | 2020-05-18 00:00:00 | Customer 2 |  | 5 |  |  |  |  |  |  |  |  |  |  |  | 1606.39 |  | 2020-05-18 00:00:00 | 2 |  | Hedge
528 | 2020-05-18 00:00:00 | Customer 3 |  |  |  |  |  |  |  |  |  |  |  | 15 |  | 148.5 |  |  | 3 | 6198078849 | Hedge
529 | 2020-05-18 00:00:00 | Customer 4 |  |  |  |  |  |  |  |  |  |  |  | 1 |  | 148.5 |  |  | 4 | (612) 402-8816 | Ordered
530 | 2020-05-19 00:00:00 | Customer 5 |  | 4 |  |  |  |  |  |  |  |  |  |  |  | 1606.74 |  |  |  |  | Hedge
533 | 2020-05-18 00:00:00 | Customer 6 |  |  |  |  |  |  |  |  |  |  |  | 20 |  | 150.1 |  |  | 1 | 9512590391 | Pulled
534 | 2020-05-18 00:00:00 | Customer 7 |  |  |  |  |  |  |  |  |  |  | 204 |  |  | 15.19 |  |  | 3 | 6197555018 | Ordered
540 | 2020-05-18 00:00:00 | Customer 8 |  |  |  |  |  |  |  |  |  |  | 700 |  |  | 14.04 |  |  |  | 8312243015 | Hedge
543 | 2020-05-18 00:00:00 | Customer 9 |  |  |  |  |  |  |  |  |  |  |  | 10 |  | 141.4 |  |  | 2 | 5107549208 | Hedge
543 |  |  |  |  |  |  |  |  |  |  |  |  | 20 |  |  | 14.24 |  |  |  |  | Ordered
545 | 2020-05-18 00:00:00 | Customer 11 |  |  |  |  |  |  |  |  |  |  | 200 |  |  | 14.34 |  | 2020-05-15 00:00:00 | 2 | 6199224882 | Ordered
546 | 2020-05-18 00:00:00 | Customer 12 |  |  |  |  |  |  |  |  |  |  | 113 |  |  | 14.42 |  |  | 2 | 6199169488 | Ordered
549 | 2020-05-18 00:00:00 | Customer 13 |  |  |  |  |  |  |  |  |  |  | 145 |  |  | 14.53 |  |  | 2 | 6199723848 | Ordered
550 | 2020-05-18 00:00:00 | Customer 14 |  |  |  |  |  |  |  |  |  |  | 100 |  |  | 14.5 |  |  | 3 | 6194935339 | Ordered
550 |  |  |  |  |  |  |  |  |  |  |  |  | 500 |  |  | 14.5 |  |  |  |  | Hedge
550 |  |  |  |  |  |  |  |  |  |  |  |  | 80 |  |  | 14.5 |  |  | 4 |  | Pulled
551 | 2020-05-18 00:00:00 | Customer 17 |  |  |  |  |  |  |  |  |  |  |  | 70 |  | 143.9 |  | 2020-05-19 00:00:00 | 1 | 8584990104 | Ordered
553 | 2020-05-18 00:00:00 | Customer 18 |  |  |  |  |  |  |  |  |  |  | 200 |  |  | 14.49 |  | 2020-05-19 00:00:00 | 1 | 6192468051 | Ordered
554 | 2020-05-18 00:00:00 | Customer 19 |  |  |  |  |  |  |  |  |  |  | 100 |  |  | 14.55 |  | 2020-05-19 00:00:00 | 1 | 8583362525 | Ordered
554 |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 |  | 144.5 |  |  |  |  | Pulled
555 | 2020-05-18 00:00:00 | Customer 21 |  |  |  |  |  |  |  |  |  |  |  | 11 |  | 144.7 |  | 2020-05-19 00:00:00 | 2 | 6198887845 | Pulled
555 |  |  |  |  |  |  |  |  |  |  |  |  | 20 |  |  | 14.57 |  |  |  |  | Ordered
556 | 2020-05-18 00:00:00 | Customer 23 |  |  |  |  |  |  |  |  |  |  |  | 34 |  | 144.22 |  | 2020-05-19 00:00:00 | 2 | [PHONE] | Hedge
556 |  |  |  |  |  |  |  |  |  |  |  |  | 351 |  |  | 14.52 |  |  | 2 |  | Pulled
558 | 2020-05-18 00:00:00 | Customer 25 |  |  |  |  |  |  |  |  |  |  |  | 5 |  | 144.4 |  | 2020-05-19 00:00:00 | 2 | [PHONE] | Pulled
558 |  |  |  |  |  |  |  |  |  |  |  |  | 100 |  |  | 14.54 |  |  | 1 |  | Hedge
559 | 2020-05-18 00:00:00 | Customer 27 |  |  |  |  |  |  |  |  |  |  | 100 |  |  | 14.54 |  | 2020-05-19 00:00:00 | 3 |  | Ordered
559 |  |  |  |  |  |  |  |  |  |  |  |  |  | 5 |  | 144.4 |  |  | 1 |  | Pulled
560 | 2020-05-18 00:00:00 | Customer 29 |  |  |  |  |  |  |  |  |  |  | 120 |  |  | 14.52 |  | 2020-05-19 00:00:00 | 3 | [PHONE] | Ordered
562 | 2020-05-18 00:00:00 | Customer 30 |  |  |  |  |  |  |  |  |  |  | 680 |  |  | 14.53 |  | 2020-05-19 00:00:00 | 2 | [PHONE] | Hedge
578 | 2020-05-18 00:00:00 | Customer 31 |  |  |  |  |  |  |  |  |  |  | 1000 |  |  | 16.37 |  | IRA |  |  | Hedge
578 |  |  |  |  |  |  |  |  |  |  |  |  |  | 100 |  | 162.7 |  |  |  |  | Hedge
580 | 2020-05-18 00:00:00 | Customer 33 |  |  | 20 |  |  |  |  |  |  |  |  |  |  | 1727.03 |  | 2020-05-19 00:00:00 |  | n/a | Hedge
581 | 2020-05-18 00:00:00 | Customer 34 |  |  |  |  |  |  |  |  |  |  | 1000 |  |  | 16.5 |  | IRA |  |  | Ordered
585 | 2020-05-18 00:00:00 | Customer 35 |  | 47 |  |  |  |  |  |  |  |  |  |  |  | 1743.79 |  | IRA | 5 |  | Ordered
586 | 2020-05-18 00:00:00 | Customer 36 | 10 |  |  |  |  |  |  |  |  |  |  |  |  | 1741.35 |  | 2020-04-15 00:00:00 |  |  | Ordered
588 | 2020-05-18 00:00:00 | Customer 37 |  | 10 |  |  |  |  |  |  |  |  |  |  |  | 1751.81 |  | 2020-04-15 00:00:00 | 1 |  | Ordered
589 | 2020-05-18 00:00:00 | Customer 38 |  |  |  |  |  |  |  |  |  |  | 60 |  |  | 17.66 |  | 2020-05-19 00:00:00 | 1 | [PHONE] | Pulled
589 |  |  |  |  |  |  |  |  |  |  |  |  | 140 |  |  | 17.66 |  |  |  |  | Pulled
590 | 2020-05-18 00:00:00 | Customer 40 | 5 |  |  |  |  |  |  |  |  |  |  |  |  | 2116.33 |  | 2020-04-16 00:00:00 | 1 |  | Pulled
592 | 2020-05-18 00:00:00 | Customer 41 |  |  |  |  |  |  |  |  |  |  | 560 |  |  | 17.69 |  | 2020-05-19 00:00:00 | 3 | [PHONE] | Pulled
593 | 2020-05-18 00:00:00 | Customer 42 |  |  |  |  |  |  |  |  |  |  |  | 15 |  | 175.2 |  | 2020-05-19 00:00:00 | 3 | [PHONE] | Pulled
594 | 2020-05-18 00:00:00 | Customer 43 |  | 1 |  |  |  |  |  |  |  |  |  |  |  | 1779.25 |  | 2020-05-19 00:00:00 | 3 | [PHONE] | Ordered
594 | 2020-05-18 00:00:00 | Customer 44 |  |  |  |  |  |  |  |  |  |  |  | 12 |  | 175.4 |  |  |  |  | Ordered
596 | 2020-05-18 00:00:00 | Customer 45 |  |  |  |  |  |  |  |  |  |  | 100 |  |  | 18.3 |  | 2020-05-19 00:00:00 |  | [PHONE] | Ordered
600 | 2020-05-18 00:00:00 | Customer 46 |  |  |  |  |  |  |  |  |  |  | 100 |  |  | 18.16 |  | 2020-05-19 00:00:00 |  | [PHONE] | Ordered
600 |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 |  | 180.6 |  |  |  |  | Ordered
601 | 2020-05-18 00:00:00 | Customer 48 |  |  |  | 7 |  |  |  |  |  |  |  |  |  | 876 |  | 2020-05-19 00:00:00 |  | [PHONE] | Ordered
601 |  |  |  |  |  | 2 |  |  |  |  |  |  |  |  |  | 1812.99 |  |  |  |  | Hedge
603 | 2020-05-18 00:00:00 | Customer 50 |  |  |  |  |  |  |  |  |  |  | 100 |  |  | 18.66 |  | 2020-05-19 00:00:00 |  | [PHONE] | Hedge
606 | 2020-05-18 00:00:00 | Customer 51 |  |  |  |  |  |  |  |  |  |  | 200 |  |  | 18.93 |  | 2020-05-19 00:00:00 |  | [PHONE] | Hedge
607 | 2020-05-18 00:00:00 | Customer 52 |  |  |  |  |  |  |  |  |  |  |  | 25 |  | 185.8 |  | 2020-05-19 00:00:00 | 1 | [PHONE] | Pulled
609 | 2020-05-18 00:00:00 | Customer 53 |  |  |  |  |  |  |  |  |  |  |  | 10 |  | 185.6 |  | 2020-05-19 00:00:00 |  | [PHONE] | Pulled
610 | 2020-05-18 00:00:00 | Customer 54 |  |  |  |  |  |  |  |  |  |  | 500 |  |  | 18.69 |  | 2020-05-19 00:00:00 |  | [PHONE] | Pulled
611 | 2020-05-18 00:00:00 | Customer 55 |  |  |  |  |  |  |  |  |  |  | 100 |  |  | 18.73 |  | 2020-05-19 00:00:00 | 1 | [PHONE] | Ordered
613 | 2020-05-18 00:00:00 | Customer 56 |  |  |  |  |  |  |  |  |  |  | 500 |  |  | 17.99 |  | 2020-05-19 00:00:00 | 1 | [PHONE] | Ordered
613 |  |  |  |  |  |  |  |  |  |  |  |  | 40 |  |  | 17.99 |  |  | 1 |  | Hedge
613 |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 |  | 178.9 |  |  | 1 |  | Hedge
614 | 2020-05-18 00:00:00 | Customer 59 |  |  |  |  |  |  |  |  |  |  | 100 |  |  | 18.09 |  | 2020-05-19 00:00:00 |  | [PHONE] | Pulled
615 | 2020-05-18 00:00:00 | Customer 60 |  | 5 |  |  |  |  |  |  |  |  |  |  |  | 1863.75 |  | 2020-05-05 00:00:00 | 1 | [PHONE] | Pulled
616 | 2020-05-18 00:00:00 | Customer 61 |  | 1 |  |  |  |  |  |  |  |  |  |  |  | 1890.19 |  | 2020-05-06 00:00:00 |  | [PHONE] | Pulled
617 | 2020-05-18 00:00:00 | Customer 62 |  |  |  |  |  |  |  |  |  |  | 100 |  |  | 18.29 |  | 2020-05-06 00:00:00 | 1 | [PHONE] | Hedge
618 | 2020-05-18 00:00:00 | Customer 63 |  |  |  |  |  |  |  |  |  |  |  | 10 |  | 182.2 |  | 2020-05-19 00:00:00 | 1 | [PHONE] | Ordered
619 | 2020-05-18 00:00:00 | Customer 64 |  |  | 5 |  |  |  |  |  |  |  |  |  |  | 1851.66 |  | 2020-05-19 00:00:00 |  | Monday.com | Ordered
620 | 2020-05-18 00:00:00 | Customer 65 |  |  |  |  |  |  |  |  |  |  |  | 10 |  | 183.9 |  | 2020-05-19 00:00:00 | 1 | [PHONE] | Hedge
621 | 2020-05-18 00:00:00 | Customer 66 |  |  | 8 |  |  |  |  |  |  |  |  |  |  | 1858.7 |  | 2020-05-07 00:00:00 | 1 | [PHONE] | Ordered
622 | 2020-05-18 00:00:00 | Customer 67 |  | 5 |  |  |  |  |  |  |  |  |  |  |  | 1905.7 |  | 2020-05-19 00:00:00 | 1 | [PHONE] | Ordered
623 | 2020-05-18 00:00:00 | Customer 68 |  |  |  |  |  |  |  | 100 |  |  |  |  |  | 22.73 |  | 2020-05-19 00:00:00 | 1 | [PHONE] | Ordered
625 | 2020-05-18 00:00:00 | Customer 69 |  |  |  |  |  |  |  | 200 |  |  |  |  |  | 22.75 |  | 2020-05-19 00:00:00 |  | [PHONE] | Ordered
625 |  |  |  | 2 |  |  |  |  |  |  |  |  |  |  |  | 1902.03 |  |  | 1 |  | Ordered
626 | 2020-05-18 00:00:00 | Customer 71 | 11 |  |  |  |  |  |  |  |  |  |  |  |  | 1851.8 |  | 2020-05-19 00:00:00 |  | [PHONE] | Hedge
627 | 2020-05-18 00:00:00 | Customer 72 |  |  |  |  |  |  |  | 200 |  |  |  |  |  | 22.75 |  | 2020-05-19 00:00:00 |  | [PHONE] | Ordered
628 | 2020-05-18 00:00:00 | Customer 73 |  |  |  | 5 |  |  |  |  |  |  |  |  |  | 1856.8 |  | 2020-05-19 00:00:00 | 1 | [PHONE] | Ordered
629 | 2020-05-18 00:00:00 | Customer 74 |  |  |  |  |  |  |  |  |  |  | 720 |  |  | 18.23 |  | 2020-05-19 00:00:00 |  | [PHONE] | Ordered
630 | 2020-05-18 00:00:00 | Customer 75 |  |  |  |  |  |  |  |  |  |  |  | 55 |  | 179.1 |  | 2020-05-19 00:00:00 |  | [PHONE] | Ordered
631 | 2020-05-18 00:00:00 | Customer 76 |  | 26 |  |  |  |  |  |  |  |  |  |  |  | 1869.37 |  | 2020-05-12 00:00:00 | 1 | [PHONE] | Ordered
632 | 2020-05-18 00:00:00 | Customer 77 |  |  |  |  | 50 |  |  |  |  |  |  |  |  | 862 |  | 2020-05-19 00:00:00 |  | 5203702315 | Ordered
632 |  |  |  |  | 75 |  |  |  |  |  |  |  |  |  |  | 1828.21 |  | 2020-05-19 00:00:00 |  |  | Hedge
633 | 2020-05-18 00:00:00 | Customer 79 | 22 |  |  |  |  |  |  |  |  |  |  |  |  | 1826 |  | 2020-05-19 00:00:00 |  |  | Ordered
633 |  |  |  | 5000 |  |  |  |  |  |  |  |  |  |  |  | 1725 |  |  |  |  | Hedge
`
 |  | Item Name
 |  |  | Gold Needing to be Hedged |  |  |  |  |  |  | Silver Needing to be Hedged