|
|
#4
06-30-2017, 10:10 AM
|
||||
|
||||
You would have to enter an IF() formula in the cells additional to the Conditional Formatting you did...
so in the same cells you would enter formula: =IF(AND(F4>=TODAY()-305,F4<=TODAY()),"Up to Date","Past Due") 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 Formula, Compare two cell's text and based on results output a number
|
Offrddrver | Excel | 4 | 03-23-2016 11:32 PM |
| Perform calc in active cell then highlight based on formula result | grexcelman | Excel Programming | 4 | 01-12-2015 11:00 AM |
| Change formula cell range based on cell value | Scoth | Excel | 4 | 10-25-2012 07:51 AM |
|
Creating formula based on if data is correct in cell
|
MattMurdock | Excel | 1 | 08-06-2012 03:11 AM |
| Is there a way to do this? (automatically enter text based on form data) | TIKKI555 | Word | 0 | 05-26-2010 09:21 AM |
Windows 10 
Office 2013
Threaded Mode