|
|
#10
03-03-2015, 04:47 AM
|
|||
|
|||
Because they have been completed within the last 365 days. I am trying to get the cells to change colors based on when their anniversity date is.
Ok the system that we have is you will enter the certificate date, they are good for one year. Therefore, I need the dates to change colors when it approaches for them to be renewed. 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Conditional Formatting | sdfrance | Excel | 3 | 01-06-2015 07:10 AM |
 Conditional formatting that ignores other formatting rules
|
info_guy2 | Excel | 1 | 07-03-2014 10:07 AM |
| conditional formatting | otuatail | Excel | 1 | 06-06-2012 05:07 AM |
|
Conditional Formatting.
|
Laurie B. | Excel | 6 | 04-09-2012 05:01 PM |
| Conditional Formatting | namedujour | Excel | 3 | 08-25-2011 01:46 PM |
Windows 8 
Office 2013
Threaded Mode