Setting an invoice tracker up and looking to have ‘due date’ highlight in green and ‘past due’ red
Hi All,
As title suggests I’m trying to set up a sheet to track paid and unpaid invoices.
Example:
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.
Hi All, As title suggests I’m trying to set up a sheet to track paid and unpaid invoices. Example: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. Read More
