Spreadsheet: 699131d1602426034-conditional-formatting-based-on-zero-value-in-another-column-cf-bills-temp-jh
Sheet: 2020 Bills

Avg Pay Date | Amount Due | AVG Paid | Annual | Qtrly | Account | Auto Pay | Credit Card | Name | Due Date | Jan (01) |  | Feb (02) |  | Mar (03) |  | Apr (04) |  | May (05) |  | Jun (06) |  | Jul (07) |  | Aug (08) |  | Sep (09) |  | Oct (10) |  | Nov (11) |  | Dec (12) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec
 |  |  | X |  |  | YES | YES | ABC | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2020-07-01 00:00:00
 |  |  |  |  |  |  | NO | DEF | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2020-01-01 00:00:00 | 2020-02-01 00:00:00 | 2020-03-01 00:00:00 | 2020-04-01 00:00:00 | 2020-05-01 00:00:00 | 2020-06-01 00:00:00 | 2020-07-01 00:00:00 | 2020-08-01 00:00:00 | 2020-09-01 00:00:00 | 2020-10-01 00:00:00 | 2020-11-01 00:00:00 | 2020-12-01 00:00:00
 |  |  |  |  |  |  | NO | GHI | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2020-01-01 00:00:00 | 2020-02-01 00:00:00 | 2020-03-01 00:00:00 | 2020-04-01 00:00:00 | 2020-05-01 00:00:00 | 2020-06-01 00:00:00 | 2020-07-01 00:00:00 | 2020-08-01 00:00:00 | 2020-09-01 00:00:00 | 2020-10-01 00:00:00 | 2020-11-01 00:00:00 | 2020-12-01 00:00:00
 |  |  |  | X |  | YES | YES | JKL | 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 200 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2020-03-02 00:00:00 |  |  | 2020-06-02 00:00:00 |  |  | 2020-09-02 00:00:00 |  |  | 2020-12-02 00:00:00
 |  |  |  |  |  |  | NO | MNO | 7 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2020-01-07 00:00:00 | 2020-02-07 00:00:00 | 2020-03-07 00:00:00 | 2020-04-07 00:00:00 | 2020-05-07 00:00:00 | 2020-06-07 00:00:00 | 2020-07-07 00:00:00 | 2020-08-07 00:00:00 | 2020-09-07 00:00:00 | 2020-10-07 00:00:00 | 2020-11-07 00:00:00 | 2020-12-07 00:00:00
 |  |  |  |  |  | YES | YES | PQR | 7 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 300 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2020-01-07 00:00:00 | 2020-02-07 00:00:00 | 2020-03-07 00:00:00 | 2020-04-07 00:00:00 | 2020-05-07 00:00:00 | 2020-06-07 00:00:00 | 2020-07-07 00:00:00 | 2020-08-07 00:00:00 | 2020-09-07 00:00:00 | 2020-10-07 00:00:00 | 2020-11-07 00:00:00 | 2020-12-07 00:00:00
 |  |  | X |  |  |  | YES | STU | 10 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2020-07-10 00:00:00
 |  |  |  |  |  |  | NO | VWX | 10 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 400 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2020-01-10 00:00:00 | 2020-02-10 00:00:00 | 2020-03-10 00:00:00 | 2020-04-10 00:00:00 | 2020-05-10 00:00:00 | 2020-06-10 00:00:00 | 2020-07-10 00:00:00 | 2020-08-10 00:00:00 | 2020-09-10 00:00:00 | 2020-10-10 00:00:00 | 2020-11-10 00:00:00 | 2020-12-10 00:00:00
 |  |  |  |  |  |  |  | YZ1 | 11 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2020-01-11 00:00:00 | 2020-02-11 00:00:00 | 2020-03-11 00:00:00 | 2020-04-11 00:00:00 | 2020-05-11 00:00:00 | 2020-06-11 00:00:00 | 2020-07-11 00:00:00 | 2020-08-11 00:00:00 | 2020-09-11 00:00:00 | 2020-10-11 00:00:00 | 2020-11-11 00:00:00 | 2020-12-11 00:00:00
 |  |  |  |  |  |  |  |  | MO. AVG | MO. SUM |  | MO. SUM |  | MO. SUM |  | MO. SUM |  | MO. SUM |  | MO. SUM |  | MO. SUM |  | MO. SUM |  | MO. SUM |  | MO. SUM |  | MO. SUM |  | MO. SUM
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | For example