This should work.
=AND((A1-TODAY())<5,(A1-TODAY())>=0)
Cheers,
Steve
great! so that works....but is there a way to copy and paste the
conditional formatting to each of my cells that contain dates? because
i think in your formula you have to change A1 to whatever cell it is,
right? so do I have to do each one manually?

Signature
Rangerbob86
SteveG - 16 Jun 2006 20:03 GMT
You can use the Format Painter. Select the first cell in your range.
Click on the Format painter (looks like a paint brush). While holding
down the left mouse button, highlight the rest of your range and
release. Or you could go to the first cell in your range (assuming it
is a column) move the mouse over the lower right hand corner of the
first cell until it changes to a black cross and double click. That
will copy it down the range.
Steve

Signature
SteveG