Combine 'conditional formatting' and 'TODAY()' function

[50gumbys]

I want to use the 'Conditional Format' feature with the TODAY() function in order to check cells for dates that fall within 10 days of today's date.
EG:
Today's date: Nov 26 2003
cell dates: Nov 29 2003 (want the special format here)
Dec 30 2003 (no special format)

Would appreciate any assistance on this - thank you so much!

 

[onlyadrafter]

Hello,

What you need to do is the following

In the cell containing NOv 29 2003 select FORMAT, CONDITIONAL FORMATTING and change CELL VALUE IS to FORMULA IS and enter the following into the space next to this.

=$C$5+10>C6

use the format painter to format other cells.

C5 contains todays date
C6 contains Nov 29 2003

Change the cell refs as required.



Hope this helps.

----------------------------------

maybe only a drafter
but the best user at this company!

 

[Mutt]

In the conditional formatting use the cell value option with "less than" option and in the formula cell type =today()+10 or if want both sides of today use the "between" option and =today()-10 and =today()+10. If find doesnt work go back to the conditional formatting box and check Excel hasn;t added some quotes around the formula - does sometimes if don't put in = sign.

 

[50gumbys]

I'm sorry I haven't been back here - but I wanted to thank you so much for your solution to my problem!!!
I appreciate that so much!
You guys are great !!