Spreadsheet: 776308d1649683593-conditional-formating-based-on-cell-value-test
Sheet: REVENUES

CID |  | BILL | YEAR | QUARTER | TYPE | START | END | FIXED | RECURRING | TOTAL HTVA | TOTAL TVAC | PAYMENT | COMMENTS
 |  | 2022-006 |  |  |  | 2022-04-01 00:00:00 |  | 2999 |  |  |  | to receive | website creation
 |  | 2022-006 |  |  |  | 2022-04-01 00:00:00 | 2022-12-31 00:00:00 |  |  |  |  | to receive | website maintenance
 |  | 2022-006 |  |  |  | 2022-04-01 00:00:00 | 2022-12-31 00:00:00 |  |  |  |  | to receive | domain name registration
 |  |  |  |  |  | 2023-01-01 00:00:00 | 2023-12-31 00:00:00 |  |  |  |  | to receive | website maintenance
 |  |  |  |  |  | 2023-01-01 00:00:00 | 2023-12-31 00:00:00 |  |  |  |  | to receive | domain name renewal
 |  |  |  |  |  | 2024-01-01 00:00:00 | 2024-12-31 00:00:00 |  |  |  |  | to receive | website maintenance
 |  |  |  |  |  | 2024-01-01 00:00:00 | 2024-12-31 00:00:00 |  |  |  |  | to receive | domain name renewal
 |  |  |  |  |  | 2025-01-01 00:00:00 | 2025-12-31 00:00:00 |  |  |  |  | to receive | website maintenance
 |  |  |  |  |  | 2025-01-01 00:00:00 | 2025-12-31 00:00:00 |  |  |  |  | to receive | domain name renewal
 |  | 2022-004 |  |  |  | 2022-02-01 00:00:00 |  | 2999 |  |  |  | received | website creation
 |  | 2022-004 |  |  |  | 2022-02-01 00:00:00 | 2022-12-31 00:00:00 |  |  |  |  | received | website maintenance
 |  |  |  |  |  | 2023-01-01 00:00:00 | 2023-12-31 00:00:00 |  |  |  |  | to receive | website maintenance
 |  |  |  |  |  | 2023-01-01 00:00:00 | 2023-12-31 00:00:00 |  | 100 |  |  | to receive | last year's automatic translations
 |  |  |  |  |  | 2024-01-01 00:00:00 | 2024-12-31 00:00:00 |  |  |  |  | to receive | website maintenance
 |  |  |  |  |  | 2024-01-01 00:00:00 | 2024-12-31 00:00:00 |  | 100 |  |  | to receive | last year's automatic translations
 |  |  |  |  |  | 2025-01-01 00:00:00 | 2025-12-31 00:00:00 |  |  |  |  | to receive | website maintenance
 |  |  |  |  |  | 2025-01-01 00:00:00 | 2025-12-31 00:00:00 |  | 100 |  |  | to receive | last year's automatic translations
 |  | 2022-003 |  |  |  | 2022-01-12 00:00:00 |  | 8.46 |  |  |  | canceled | domain name registration
 |  | 2022-002 |  |  |  | 2022-01-12 00:00:00 |  | 8.46 |  |  |  | received | domain name registration
 |  | 2022-001 |  |  |  | 2022-01-12 00:00:00 |  | 8.46 |  |  |  | canceled | domain name registration
 |  | 2021-007 |  |  |  | 2021-12-01 00:00:00 |  | 1599 |  |  |  | received | website creation
 |  | 2021-008 |  |  |  | 2021-12-01 00:00:00 | 2021-12-31 00:00:00 |  |  |  |  | received | website maintenance
 |  | 2021-008 |  |  |  | 2022-01-01 00:00:00 | 2022-12-31 00:00:00 |  |  |  |  | received | website maintenance
 |  | 2021-008 |  |  |  | 2023-01-01 00:00:00 | 2023-12-31 00:00:00 |  |  |  |  | received | website maintenance
 |  | 2021-008 |  |  |  | 2024-01-01 00:00:00 | 2024-12-31 00:00:00 |  |  |  |  | received | website maintenance
 |  |  |  |  |  | 2025-01-01 00:00:00 | 2025-12-31 00:00:00 |  |  |  |  | to receive | website maintenance
 |  | 2021-005 |  | Q4 |  | 2021-10-01 00:00:00 |  | 500 |  |  |  | received | website creation
 |  | 2021-006 |  | Q4 |  | 2021-10-01 00:00:00 | 2022-12-31 00:00:00 |  |  |  |  | received | website maintenance
 |  |  |  |  |  | 2023-01-01 00:00:00 | 2023-12-31 00:00:00 |  |  |  |  | to receive | website maintenance
 |  |  |  |  |  | 2024-01-01 00:00:00 | 2024-12-31 00:00:00 |  |  |  |  | to receive | website maintenance
 |  |  |  |  |  | 2025-01-01 00:00:00 | 2025-12-31 00:00:00 |  |  |  |  | to receive | website maintenance
 |  | 2021-003 |  | Q3 |  | 2021-07-01 00:00:00 |  |  |  |  |  | received | website creation
 |  | 2021-004 |  | Q3 |  | 2021-07-01 00:00:00 | 2021-12-31 00:00:00 |  |  |  |  | received | website maintenance
 |  | 2022-007 |  |  |  | 2022-01-01 00:00:00 | 2022-12-31 00:00:00 |  |  |  |  | to receive | website maintenance
 |  |  |  |  |  | 2023-01-01 00:00:00 | 2023-12-31 00:00:00 |  |  |  |  | to receive | website maintenance
 |  |  |  |  |  | 2024-01-01 00:00:00 | 2024-12-31 00:00:00 |  |  |  |  | to receive | website maintenance
 |  |  |  |  |  | 2025-01-01 00:00:00 | 2025-12-31 00:00:00 |  |  |  |  | to receive | website maintenance
 |  | 2021-001 |  | Q3 |  | 2021-07-01 00:00:00 |  |  |  |  |  | received | website creation
 |  | 2021-002 |  | Q3 |  | 2021-07-01 00:00:00 | 2021-12-31 00:00:00 |  |  |  |  | received | website maintenance
 |  | 2022-005 |  |  |  | 2022-01-01 00:00:00 | 2022-12-31 00:00:00 |  |  |  |  | received | website maintenance
 |  |  |  |  |  | 2023-01-01 00:00:00 | 2023-12-31 00:00:00 |  |  |  |  | to receive | website maintenance
 |  |  |  |  |  | 2024-01-01 00:00:00 | 2024-12-31 00:00:00 |  |  |  |  | to receive | website maintenance
 |  |  |  |  |  | 2025-01-01 00:00:00 | 2025-12-31 00:00:00 |  |  |  |  | to receive | website maintenance