|
|
#1
09-11-2014, 03:04 PM
|
|||
|
|||
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. 
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 Date Conditional Formatting
|
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 |
|
Conditional formatting question based on cell date
|
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 |
Windows 7 64bit 
Office 2010 32bit
Threaded Mode