Highlight cell after date in that cell has passed and nothing in adjacent cell

[SharonM669]

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 competed. What I need please is a formula that highlights the due date if there is no date completed in column D. e.g. for the start of placement meeting - if there is no completed date entered after the 20-04-2021, the due date gets highlighted in yellow. Any advice would be much appreciated. Thank you so much.

Required Meetings
Type	Number Required	Due Date	Completed
Start of Placement	1	20-04-2021	11-04-2021
Reflection	1 Every 3 Calendar Months	28-06-2021
Reflection		26-09-2021
Reflection		25-12-2021
Reflection		11-03-2022
Reflection
Reflection

[#2]

@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.

[#3 · Accepted solution]

@Riny_van_EekelenThank you so much. It worked perfectly. You are very kind. Have a great day :)