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

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

On 17 May, 03:08, KC Rippstein hotmail com <kcrippstein<atdot wrote:
Select F2 and G2, then do FormatConditionalFormatting. *You will add twoconditionalformats:
* 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 anotherconditionalformat 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 don’t even mind having helper
columns. I want ColorFormattingbased 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- Hide quoted text -

- Show quoted text -

Thank you very much. It did work. Sorry for the delay in replying. I
wanted to check it on Excel 2003, which I only have at work. Now, how
can I filter these cells according to colour in excel 2003.

Regards,
Lee

Check out Chip Pearson's site for tips on sorting by color:
http://www.cpearson.com/excel/sortbycolor.htm

--
Please remember to indicate when the post is answered so others can benefit
from it later.


"Lee" wrote:

On 17 May, 03:08, KC Rippstein hotmail com <kcrippstein<atdot wrote:
Select F2 and G2, then do FormatConditionalFormatting. You will add twoconditionalformats:
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 anotherconditionalformat 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 ColorFormattingbased 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- Hide quoted text -

- Show quoted text -

Thank you very much. It did work. Sorry for the delay in replying. I
wanted to check it on Excel 2003, which I only have at work. Now, how
can I filter these cells according to colour in excel 2003.

Regards,
Lee