Forum Discussion
Solved
Highlight cell after date in that cell has passed and nothing in adjacent cell
Hi everyone. I'm sorry if this has been answered previously but I can't find the information I need. I have a spreadsheet that contains a due date in cells column c. In column D I have a date compete...
Riny_van_EekelenThank you so much. It worked perfectly. You are very kind. Have a great day 🙂
SharonM669 Assuming the Due Dates are in column C, starting from row 3 and down, the following conditional formatting rule will highlight due dates when the due date is not blank, and the completion date is blank and todays date is past the due date.
=AND(NOT(ISBLANK(C3)),ISBLANK(D3),C3<=TODAY())
Apply this rule to a range starting at C3 and as far down needed.
Riny_van_EekelenThank you so much. It worked perfectly. You are very kind. Have a great day 🙂