Conditional Formatting by Date (Month)

  • Thread starter Thread starter CP
  • Start date Start date
C

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?
 
I guess this Conditional Format formula will do what you want...

=AND(F1<DATE(YEAR(NOW()),MONTH(NOW())+1,DAY(NOW())),F1<>"")
 
Make sure the Analysis ToolPak Add-in is activated.

Assuming you're starting in F2
Format - Conditional Format.
Formula is:
=F2<=EOMONTH(TODAY(),1)
 
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
 
I already have the answer now thank you.

*Analysis ToolPak Add-in* - what and where is this?
 
Under Tools - Add-ins, you'll see a variety of add-ins that you can choose to
activate in XL.
 
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
 
Back
Top