Conditional Formatting based on dynamic Date
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.
|