|
|
#3
03-02-2015, 08:58 PM
|
|||
|
|||
I have done this but all the cells are coming up yellow. Unless I have entered them wrong. I have entered the following dates just to check the conditional formatting.
A1: 3/4/14 A2: 4/4/14 A3: 5/4/14 A4: 6/4/14 With conditional Formatting: cell value less than =today()+365-90 yellow cell value less than =today()+365-60 amber cell value less than =today()+365+30 red cell value greater than =today()+91 green This is correct? 
|
|
|
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