Looks like no one’s replied in a while. To start the conversation again, simply ask a new question.

Question:

Question: Conditional Formatting for Due dates of payments and received payments

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

Posted on

Reply

Page content loaded

Mar 13, 2018 8:30 AM in response to SnapServices In response to SnapServices

Hi SnapServices,


With two IF conditions:


  • payment due date has/has not passed
  • the payment has/has not been made


the AND function is your friend.

See if this works for you. Add another column (D) to test B and C

User uploaded file

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.


User uploaded file

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.

Mar 13, 2018 8:30 AM

Reply Helpful
User profile for user: SnapServices

Question: Conditional Formatting for Due dates of payments and received payments