Conditional Formatting by Date (Month)
 

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?

Conditional Formatting by Date (Month)
 

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" wrote in message
...
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?

Conditional Formatting by Date (Month)
 

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?

Conditional Formatting by Date (Month)
 

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

=AND(F10,F1<DATE(YEAR(TODAY()),MONTH(TODAY())+1,D AY(TODAY())))

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


"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?

Conditional Formatting by Date (Month)
 

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

"Jacob Skaria" wrote:

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

=AND(F10,F1<DATE(YEAR(TODAY()),MONTH(TODAY())+1,D AY(TODAY())))

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


"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?

Conditional Formatting by Date (Month)
 

I already have the answer now thank you.

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

"Luke M" wrote:

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?

Conditional Formatting by Date (Month)
 

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

Luke M
*Remember to click "yes" if this post helped you!*


"CP" wrote:

I already have the answer now thank you.

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

"Luke M" wrote:

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?

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?