Setting an invoice tracker up and looking to have 'due date' highlight in green and 'past due' red

Copper Contributor

Hi All,


As title suggests I'm trying to set up a sheet to track paid and unpaid invoices.



Date (A6), Client (B6), Invoice number (C6), Location (D6), Date Completed (E6), Rate (F6), Due Date (G6) and Date Paid (H6)


Can anyone help me work out how to have cell (G6) turn red if it goes over seven days from (E6) so I can send a friendly reminder to my clients.


Formulas for this have me stumped.



1 Reply


Select G6 (or a range in column G from G6 down).

On the home tab of the ribbon, click Conditional Formatting > New Rule...

In the Style box, click Classic.

Select 'Use a formula to determine which cells to format'.

Enter the formula




(The formula refers to the cells in the row of the active cell)

Click Format...

Activate the Fill tab.

Click OK, then OK.

Select red.