Forum Discussion
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),...
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
=$G6>$E6+7
(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.