Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
conditional formatting for cell date to equal today's date | Excel Worksheet Functions | |||
conditional formatting match month | Excel Discussion (Misc queries) | |||
Conditional Format for a date 1 month before Expiration in Excel 2 | Excel Worksheet Functions | |||
Date arithmetic: adding 1 month to prior end of month date | Excel Worksheet Functions | |||
Conditional Formatting based on month name | Excel Discussion (Misc queries) |