Aug 17 2021 11:24 PM
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 |
Aug 18 2021 12:25 AM
@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.
Aug 18 2021 01:23 AM
Solution@Riny_van_EekelenThank you so much. It worked perfectly. You are very kind. Have a great day :)
Aug 18 2021 01:23 AM
Solution@Riny_van_EekelenThank you so much. It worked perfectly. You are very kind. Have a great day :)