![]() |
#1
|
|||
|
|||
![]()
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. |
Thread Tools | |
Display Modes | |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
teza2k06 | Excel | 1 | 08-09-2014 09:58 AM |
Conditional Formatting based on Value of Another Cell | SteveBump | Excel | 3 | 03-07-2014 09:16 AM |
![]() |
Cosmo | Excel | 2 | 04-08-2013 12:12 PM |
Conditional Formatting Expiration Dates Based on Text in Adjacent Cell | Frogggg | Excel | 1 | 10-25-2011 08:44 PM |
dynamic charts based on mail merge fields | jwajehee | Mail Merge | 0 | 10-05-2011 09:47 AM |