#16
|
|||
|
|||
I know this one has been solved but I am encountering a similar issue I am going back in forth with this I pretty sure that I am just missing it by a little. 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 | 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 |