Hi,

I've used conditional formatting to highlight dates which are due this week and next week, but now I need to highlight which dates are overdue.

Each row is a task/job.
I have a 'Due Date' column.
I also have a 'Date Completed' column.

How do I highlight the overdue dates based on their due date (not today's date)?
And once I have entered a date in the 'Date Completed' column, I need the overdue highlight to be removed.

I hope this makes sense.
Appreciate any help

Thanks,
AmberMarieRose