Select D3, then,
<Format <Conditional Format
Click "Formula Is",
And enter this:

=AND(C3=DATEVALUE("10/20/2005"),C3<=DATEVALUE("10/31/2005"))

Click on "Format",
And choose whatever you like,
then <OK <OK

--
HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


"DocMartigan" wrote in message
...
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