Conditional Formatting by Date (Month)

[CP]

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?

[Rick Rothstein]

I guess this Conditional Format formula will do what you want...

=AND(F1<DATE(YEAR(NOW()),MONTH(NOW())+1,DAY(NOW())),F1<>"")

--
Rick (MVP - Excel)

"CP" <C...@discussions.microsoft.com> wrote in message
news:56D32F62-95A2-4638...@microsoft.com...

[Luke M]

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!*

[Jacob Skaria]

Your example and query contradicts..If you mean today+1month try the below

=AND(F1>0,F1<DATE(YEAR(TODAY()),MONTH(TODAY())+1,DAY(TODAY())))

If this post helps click Yes
---------------
Jacob Skaria

[CP]

Ricks answer worked - was more likely my explanation was, thank you

[CP]

I already have the answer now thank you.

*Analysis ToolPak Add-in* - what and where is this?

[Luke M]

Under Tools - Add-ins, you'll see a variety of add-ins that you can choose to
activate in XL.

[T. Valko]

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.

Insert>Name>Define
Name: TargetDate
Refers to: =EOMONTH(TODAY(),1)

Then, as the formatting formula:

=F2<=TargetDate

--
Biff
Microsoft Excel MVP

"Luke M" <Lu...@discussions.microsoft.com> wrote in message
news:A935D6F2-F41E-408A...@microsoft.com...