I am working on a spreadsheet that will notify us when certain projects are
approaching their deadlines, and when they have passed them.

Long story short, I need a cell to format itself depending on another cell
that has the current date in it.

I cannot seem to get anything to work.

As an example, I need cell D3 to turn red when the current date is between
10/20/2005 and 10/31/2005 in cell C3.

Do I use a range? the "AND" function? I thought that something like this
would work,

IF(AND(C3==10/20/2005, C3<=10/31/2005),"TRUE","FALSE")

I tried this and much simpler formulas, but nothing seems to work.
Any help would be greatly appreciated

I did get