D2 has start date( Goods ordered) 02/06/08
E2 has end date (Due date) 16/06/008
F2 is for order confirmation – either blank or Yes
G2 is a date for Goods Received

Please help.

In F2 or G2 which ever is convenient, I don’t even mind having helper
columns. I want Color Formatting based on following criteria:

If F2 & G2 are blank & its 7 days before F2, I want to show Brown
color for chasing order confirmation.

If F2 or G2 are blank from 2 days before due date and until the F2 or
G2 are populated, I want to show red colour.

I hope this makes sense.

Regards,

Lee