MrExcel Publishing
Your One Stop for Excel Tips & Solutions

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.