Conditional formatting based on snother cell

Question

I have a list of due dates in column j and a list of dates when the reports were submitted in column k

If tge due date is less than today (as in its now overdue) i want to put some formatting on thst overdue date to make it stand out but as soon as the submitted date is filled out i want the formatting to return to normal

How do I accomplish this?

Answer 1

Assume your due date starts on row 2. Select all the due dates and add a conditional formatting rule as follows:

=AND(I2<TODAY(), ISBLANK(J2))

and select the highlight format you want.