View Single Post
Old 09-11-2014, 03:04 PM
Modifier1000 Modifier1000 is offline Windows 7 64bit Office 2010 32bit
Join Date: Sep 2014
Posts: 2
Modifier1000 is on a distinguished road
Question 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.
Attached Images
File Type: png Conditional Formatting based on Dynamic Date.png (42.1 KB, 22 views)
Reply With Quote