Conditional Formatting based on dynamic Date

[Modifier1000]

Hello all, brand new to the site.</SPAN>

Anyways, </SPAN>I have an Excel file with conditional formatting (screenshot attached), if the condition is true, the entire row shall be highlighted (to Green) and have a top/bottom border.</SPAN></SPAN>

What I really need is for the condition to format based on the following criteria:</SPAN>


-Highlight (Green) w/borders if the day for the previous month is greater than the 14^th</SPAN>.</SPAN>
Note1: ‘Previous month’ is the month before the Excel file was created.
Note2: The date is in the format: Date [3/14/01]</SPAN>

[/URL][/IMG]

Any help is much appreciated.</SPAN>

 

[cyrilbrd]

Hi,
try =AND(T3>41806,T3<41820)

 

[Modifier1000]

Thank you for responding, but doesn't the formula you provided only evaluate between two specific dates (6/16/2014 & 6/30/2014)?

I need to evaluate only on the days (15th thru End-of-Month) based on the previous month from whenever the file was created.

For instance:
If the file was created on March, I need the Condition based the previous month (February) for the 15th thru End-of-Month.
If the file was created on April, I need the Condition based the previous month (March) for the 15th thru End-of-Month.
If the file was created on May, I need the Condition based the previous month (April) for the 15th thru End-of-Month.
...and so on.

 

[cyrilbrd]

try =AND(DAY(T3)>=15,T3<=EOMONTH(T3,0))

 

[Modifier1000]

Thank you, it's working so far.

 

[cyrilbrd]

Thank you, it's working so far.

Most welcome, thanks for the feedback...