Combine 'conditional formatting' and 'TODAY()' function
Combine 'conditional formatting' and 'TODAY()' function
(OP)
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!
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!





RE: Combine 'conditional formatting' and 'TODAY()' function
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!
RE: Combine 'conditional formatting' and 'TODAY()' function
RE: Combine 'conditional formatting' and 'TODAY()' function
I appreciate that so much!
You guys are great !!