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 14th</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>
Any help is much appreciated.</SPAN>