Conditional formatting for dates in Excel

Hi all,

I have a question regarding conditional formatting, hopefully someone could help me. I've tried playing about with it very briefly but probably easier coming here I work for a company who run a very low scale sales business in coordination with our testing business, so we may only sell a few items a week but I'm looking to track stuff a lot easier than the company currently does.

So basically, I have a sales spreadsheet I am making, and need to be able to format the "Date Due" column to change colour to show overdue deliveries. I have the "Date Due" column, followed by "Sent for Delivery" column - the latter is already conditionally formatted to turn Red or Green, depending on whether it says N(o) or Y(es). I also want this colour to format in the date column...

e.g. I have 2 items to be delivered by 25th September 2017, the "Sent for Delivery" column is red as the items have not been sent yet, however I would then want the "Date Due" column to remain green to show that delivery is not overdue yet...

Conversely, if the items are due 19th September 2017 (yesterday) but the delivery column is still showing red for not been sent yet, I would like the "Date Due" column to change to red...

Is this possible is the answer I'm looking for? And if so, how? I imagine it might combine conditional formatting with IF functions or something?

Thanks a lot in advance,
John

Thanks a lot Kaper, this seems to have worked with a little fiddling about!