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?