|
|
#1
06-30-2017, 07:30 AM
|
|||
|
|||
Auto enter data based on formula in another cell?
Ok guys Basically i have a spreadsheet using conditional formatting, and have it set so it changes color based on range of dates ie( if its beyond 365 days the cell turns red, if its under a year the cell turns green. Ive pasted one of the rules below in case i didnt explain clearly.
=AND(F4>=TODAY()-305,F4<=TODAY()) <-- and set color to green What I want to do is have the Cell auto fill with Text " Up to Date" or Out of Date based on the date entered in source cell. Any help would be greatly appreciated. Thanks 
|
|
|
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 7 32bit 
Office 2010 32bit
Threaded Mode