Conditional Formatting for Excel 2003

[Lee]

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

 

[KC Rippstein hotmail com>]

Select F2 and G2, then do Format>Conditional 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

 

[Lee]

Select F2 and G2, then do Format>ConditionalFormatting.  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.










- 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

 

[KC Rippstein hotmail com>]

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