|
|
#1
12-11-2016, 01:27 PM
|
|||
|
|||
6 month conditional formatting
I am trying to do this one by 180 days.
Yellow= after 150 days I was using =TODAY()+150 Red= after 180 days I was using =TODAY()+180 Green= between date taken and 150 days Red= If blank I have only played with the yellow and red right now I can't get them right I have messed with them a little. 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 Conditional formatting
|
dayperson | Excel | 1 | 02-23-2016 09:07 AM |
| Help with if and conditional formatting | piper7971 | Excel | 11 | 06-10-2015 12:07 AM |
|
Conditional formatting that ignores other formatting rules
|
info_guy2 | Excel | 1 | 07-03-2014 10:07 AM |
| Conditional Formatting | jdc15371 | Excel | 2 | 06-26-2014 06:34 AM |
| conditional formatting | otuatail | Excel | 1 | 06-06-2012 05:07 AM |
Windows 10 
Office 2016
Threaded Mode