Archive of Mr Excel Message Board
Back to Forms in Excel VBA archive index
Back to archive home
Date Formula with Blinking Text NotePosted 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)?
Re: Date Formula with Blinking Text NotePosted 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.
This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store
to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.