Conditional Formatting by Date (Month)
That won't work in Excel versions 2003 and earlier. You can't directly use
functions that are in the ATP.
You'd have to use a defined name.
InsertNameDefine
Name: TargetDate
Refers to: =EOMONTH(TODAY(),1)
Then, as the formatting formula:
=F2<=TargetDate
--
Biff
Microsoft Excel MVP
"Luke M" wrote in message
...
Make sure the Analysis ToolPak Add-in is activated.
Assuming you're starting in F2
Format - Conditional Format.
Formula is:
=F2<=EOMONTH(TODAY(),1)
--
Best Regards,
Luke M
*Remember to click "yes" if this post helped you!*
"CP" wrote:
I want to format a Date Column
If Column F is less than any date from today + 1month
Meaning today being 2/9/09 anything in F that is less than 31/10/09
Any guidance please?
|