Date Formula with Blinking Text Note
Posted by Gerre Nelson on July 24, 2001 10:41 AM
In an Excel spreadsheet, how would I write a formula if I have an expired date of 8/24/01 and need a blinking warning text to notify a person 2 weeks before the expired date (8/10/01)?
Posted by Ian on July 24, 2001 2:45 PM
There are add-ins/code etc I've been watching on/around this site. but why not just highlight using conditional formating.
Cell Value Is_Between =today()-14 AND =today()
hope this is a short term solution.
Ian
