Spreadsheet: 807143d1669764708-conditional-formatting-to-colour-cells-based-on-date-x-working-days-working-copy
Sheet: Open Quotes

 |  |  |  |  | Open Quotes |  | Quotes to Follow up | Late Quotes |  | Win Rate %
Operations Quote Status Update |  |  |  |  |  |  |  |  |  | I need the win percentage to populate
Project | Satus | Company | Contact | [NAME] | Quote Received | Days | Client Requested Date | Estimated Due Date | [NAME] | Follow up Date | Estimated Ready  Date | Date Submitted | Bid Form | Request Type | Designer | Sales Rep | Designer Rep | Job Awarded | Notes
 | New | [NAME] | [NAME] |  | 2022-11-15 00:00:00 | 5 | N/A |  |  |  | 2022-11-24 00:00:00 | 2022-11-23 00:00:00 | NO | PROD | Whitespace Interiors | [NAME] | [NAME] | Yes
 | New | PMI | [NAME] |  | 2022-11-16 00:00:00 | 5 | 2022-12-02 00:00:00 |  |  |  |  |  | YES | MR | AvroKo | [NAME] | [NAME] | No
 |  |  |  |  | 2022-11-17 00:00:00 | 5
 |  |  |  |  | 2022-11-18 00:00:00 | 5
 |  |  |  |  | 2022-11-19 00:00:00 | 5
 |  |  |  |  | 2022-11-20 00:00:00 | 5
 |  |  |  |  | 2022-11-21 00:00:00 | 5
 |  |  |  |  | 2022-11-22 00:00:00 | 5
 |  |  |  |  | 2022-11-23 00:00:00 | 5
 |  |  |  |  | 2022-11-24 00:00:00 | 5
 |  |  |  |  | 2022-11-25 00:00:00 | 5
 |  |  |  |  | 2022-11-26 00:00:00 | 5
 |  |  |  |  | 2022-11-27 00:00:00 | 5
 |  |  |  |  | 2022-11-28 00:00:00 | 5
 |  |  |  |  | 2022-11-29 00:00:00 | 5
 |  |  |  |  | 2022-11-30 00:00:00 | 5
 |  |  |  |  | 2022-12-01 00:00:00 | 5
 |  |  |  |  | 2022-12-02 00:00:00 | 5
 |  |  |  |  | 2022-12-03 00:00:00 | 5
 |  |  |  |  | 2022-12-04 00:00:00 | 5
 |  |  |  |  | 2022-12-05 00:00:00 | 5
 |  |  |  |  | 2022-12-06 00:00:00 | 5
 |  |  |  |  | 2022-12-07 00:00:00 | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5