I want to highlight a cell in red if the payment due date has passed but highlight in green if the payment has been made. Payment due date is in one column and payment received date is in another, how do I do this?
MacBook Air
Hi SnapServices,
With two IF conditions:
the AND function is your friend.
See if this works for you. Add another column (D) to test B and C
Formula in D2 (and Fill Down)
=IF(AND(TODAY()>B2,C2=""),A2,"")
If the due date is less than (earlier than) TODAY and a cell in C is blank ("") then insert the client name (A) from that row into a D cell, else insert "".
That prepares the table for Conditional Highlighting in all Body Cells in Column A. Select the Body Cells in A.
That Rule will automatically fill and adjust to all column A Body Cells.
TODAY here in Australia is 14 March 2018 😎.
Please reply with questions.
Regards,
Ian.
Edit. Please ignore.
Sorry, I misread the question.
Back to the drawing board.
Conditional Formatting for Due dates of payments and received payments
