Hello all, brand new to the site.

Anyways, 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.

What I really need is for the condition to format based on the following criteria:

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



Any help is much appreciated.

Attached Images

Conditional Formatting based on Dynamic Date.png (42.1 KB, 24 views)

Please post a sample sheet. Pics are nice to look at but useless to work with

__________________
Using O365 v2407 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

Attached is a sample sheet I created.

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.

Attached Files

Conditional Formatting between 15th and End-of-Previous Month.xlsx (11.2 KB, 12 views)