One quick question.

Where do i add the message "Overdue" in the formula you gave me?

"Herbert Seidenberg" wrote:

I second Suleman's suggestion.
If you have these dates, starting at A1
1/1/2007 1/14/2007 1/29/2007 2/13/2007
enter this conditional format formula for A2:A4
=DATEDIF($A$1,B$1,"d")(COLUMN()-1)*14
Cell D3 should turn red.