Conditional Formatting Help

[Ken]

Cols A, B, C formatted mm/dd/yy

Cols A & B contain a target completion date window ...
Col C contains actual completion date or is blank ...
Col D contains Comments when target dates not met ...

When date in Col C falls between dates in Cols A&B ... OK

What I need? I would like to set conditional formatting
in Col D ... When:

Col C is Blank & Today is > than date in Col B
or
Col C contains date which is outside of dates in Cols A&B

Col A Col B Col C Col D
======== ======== ======== ===============================
01/07/03 02/07/03 01/02/03 C < A (format)
10/15/02 03/15/03 02/07/03 C between A&B (no format)
02/20/03 06/15/03 C Blank, Today > B (format)
04/06/03 06/06/03 07/10/03 C > B (format)
04/19/03 10/03/03 C Blank, Today < B (no format)

As always ... my Thanks to the many Wizards on this
board ... Kha

 

[Bob Phillips]

Ken,

In CF for D1, use a condition of FormulaIs with this formula
=AND(OR(C1<>"", B1<=TODAY()),OR(C1<A1,C1>B1))
and the select Format to set the colour.

Copy down column DO.