Select F2 and G2, then do FormatConditional Formatting. You will add two
conditional formats:
the first one, change the type to "Formula Is" and type this in:
=AND(TODAY()-E2<3,F2="",G2="")
change the pattern to red
then add another conditional format using "Formula Is" and type this in:
=AND(TODAY()-E2<8,F2="",G2="")
change the pattern to brown
--
Please remember to indicate when the post is answered so others can benefit
from it later.


"Lee" wrote:

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 dont 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