Spreadsheet: 771703d1646803851-conditional-formatting-for-multiple-text-in-excel-permit-register-example-9-3-22
Sheet: Job Register

ABC Job Number | Address | Job Description | Client | Job Received | Quote Sent | Date of Confirmation  to Proceed | Permit Number | Building Permit Issue Date | Building Permit [NAME] (2 Years) | BUILDING PERMIT | OCCUPANCY PERMIT | Inspection Status | Job Notes | BUILDING PERMIT INVOICE | OCCUPANCY PERMIT INVOICE
ABC-21001 | Address 1 | Description 1 | ABC Company | 2021-04-01 00:00:00 |  | 2021-04-05 00:00:00 | 001/001/001 | 2021-01-01 00:00:00 |  | 2021-05-01 00:00:00 | 2021-05-01 00:00:00
ABC-21002 | Address 2 | Description 2 | Client 2 | 2021-04-02 00:00:00 | 2021-04-04 00:00:00 | 2021-04-06 00:00:00 | 001/001/002 | 2021-01-02 00:00:00 |  | 2021-05-02 00:00:00 | READY
ABC-21003 | Address 3 | Description 3 | 123 Concrete | 2021-04-03 00:00:00 | 2021-04-05 00:00:00 | 2021-04-07 00:00:00 | 001/001/003 | 2021-01-03 00:00:00 |  | 2021-05-03 00:00:00 | FINAL
ABC-21004 | Address 4 | Description 4 | Client 4 | 2021-04-04 00:00:00 | 2021-04-06 00:00:00 | 2021-04-08 00:00:00 | 001/001/004 | 2021-01-04 00:00:00 |  | 2021-05-04 00:00:00 | APPROVE
ABC-21005 | Address 5 | Description 5 | Client 5 | 2021-04-05 00:00:00 | 2021-04-07 00:00:00 | 2021-04-09 00:00:00 | 001/001/005 | 2021-01-05 00:00:00 |  | APROVE
ABC-21006 | Address 6 | Description 6 | Client 6 | 2021-04-06 00:00:00 | 2021-04-08 00:00:00 | 2021-04-10 00:00:00 | 001/001/006 | 2021-01-06 00:00:00 |  | 2021-05-05 00:00:00 | PARTIAL OP
ABC-21007 | Address 7 | Description 7 | ABC Company | 2021-04-07 00:00:00 |  | 2021-04-11 00:00:00 | 001/001/007 | 2021-01-07 00:00:00 |  | 2021-05-06 00:00:00 | OP
ABC-21008 | Address 8 | Description 8 | Client 8 | 2021-04-08 00:00:00 | 2021-04-10 00:00:00 | 2021-04-12 00:00:00 | 001/001/008 | 2021-01-08 00:00:00 |  | N/A | READY
ABC-21009 | Address 9 | Description 9 | 000 Houses | 2021-04-09 00:00:00 |  | 2021-04-13 00:00:00 | 001/001/009 | 2021-01-09 00:00:00 |  | - | APPROVE
ABC-21010 | Address 10 | Description 10 | Client 10 | 2021-04-10 00:00:00 | 2021-04-12 00:00:00 | 2021-04-14 00:00:00 | 001/001/010 | 2021-01-10 00:00:00 |  | READY
ABC-21011 | Address 11 | Description 11 | Client 11 | 2021-04-11 00:00:00 | 2021-04-13 00:00:00 | 2021-04-15 00:00:00 | 001/001/011 | 2021-01-11 00:00:00 |  | READY | READY
ABC-21012 | Address 12 | Description 12 | 123 Concrete | 2021-04-12 00:00:00 | 2021-04-14 00:00:00 | 2021-04-16 00:00:00 | 001/001/012 | 2021-01-12 00:00:00
ABC-21013 | Address 13 | Description 13 | Client 13 | 2021-04-13 00:00:00 | 2021-04-15 00:00:00 | 2021-04-17 00:00:00 | 001/001/013 | 2021-01-13 00:00:00 |  | READY
ABC-21014 | Address 14 | Description 14 | [NAME] | 2021-04-14 00:00:00 |  | 2021-04-18 00:00:00 | 001/001/014 | 2021-01-14 00:00:00 |  | 2021-05-04 00:00:00 | READY
ABC-21015 | Address 15 | Description 15 | Client 15 | 2021-04-15 00:00:00 | 2021-04-17 00:00:00 | 2021-04-19 00:00:00 | 001/001/015 | 2021-01-15 00:00:00 |  | 2021-05-05 00:00:00 | PARTIAL READY
ABC-21016 | Address 16 | Description 16 | Client 16 | 2021-04-16 00:00:00 | 2021-04-18 00:00:00 | 2021-04-20 00:00:00 | 001/001/016 | 2021-01-16 00:00:00
ABC-21017 | Address 17 | Description 17 | 000 Houses | 2021-04-17 00:00:00 |  | 2021-04-21 00:00:00 | 001/001/017 | 2021-01-17 00:00:00
ABC-21018 | Address 18 | Description 18 | Client 18 | 2021-04-18 00:00:00 | 2021-04-20 00:00:00 | 2021-04-22 00:00:00 | 001/001/018 | 2021-01-18 00:00:00
ABC-21019 | Address 19 | Description 19 | Client 19 | 2021-04-19 00:00:00 | 2021-04-21 00:00:00 | 2021-04-23 00:00:00 | 001/001/019 | 2021-01-19 00:00:00
ABC-21020 | Address 20 | Description 20 | [NAME] | 2021-04-20 00:00:00 |  | 2021-04-24 00:00:00 | 001/001/020 | 2021-01-20 00:00:00
ABC-21021 | Address 21 | Description 21 | Client 21 | 2021-04-21 00:00:00 | 2021-04-23 00:00:00 | 2021-04-25 00:00:00 | 001/001/021 | 2021-01-21 00:00:00
ABC-21022 | Address 22 | Description 22 | Client 22 | 2021-04-22 00:00:00 | 2021-04-24 00:00:00 | 2021-04-26 00:00:00 | 001/001/022 | 2021-01-22 00:00:00 |  | APPROVE
ABC-21023 | Address 23 | Description 23 | Client 23 | 2021-04-23 00:00:00 | 2021-04-25 00:00:00 | 2021-04-27 00:00:00 |  | N/A |  | BP
ABC-21024 | Address 24 | Description 24 | 000 Houses | 2021-04-24 00:00:00 |  | 2021-04-28 00:00:00 |  |  |  | BP
ABC-21025 | Address 25 | Description 25 | Client 25 | 2021-04-25 00:00:00 | 2021-04-27 00:00:00 | 2021-04-29 00:00:00 |  |  |  | BP
ABC-21026 | Address 26 | Description 26 | Client 26 | 2021-04-26 00:00:00 | 2021-04-28 00:00:00 | 2021-04-30 00:00:00 | 001/001/026 | 2021-01-26 00:00:00 |  | APPROVE
ABC-21027 | Address 27 | Description 27 | ABC Company | 2021-04-27 00:00:00
ABC-21028 | Address 28 | Description 28 | 000 Houses | 2021-04-28 00:00:00
ABC-21029 | Address 29 | Description 29 | Client 29 | 2021-04-29 00:00:00
ABC-21030 | Address 30 | Description 30 | Client 30 | 2021-04-30 00:00:00
ABC-21031
ABC-21032
ABC-21033
ABC-21034
ABC-21035
ABC-21036
ABC-21037
ABC-21038
ABC-21039
ABC-21040