MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Date Formula (Repost)


Posted by Gerre Nelson on July 25, 2001 8:42 AM

In column A1 I have an expired date of 8/4/01; in column B1 I have a notification date of 7/25/01 (to notify 10 days before 8/4/01).

Problem: I need a formula for each time I open the spreadsheet the notification dates are alerts, prompts, or reminders for myself.

Question: What formula(s) would I use to make the notification dates (7/25/01) stand out as alerts, prompts, flashing/blinking text, or reminders, besides making the font bold, colored? Can Excel do this or do I need another spreadsheet application?


Posted by Mark W. on July 25, 2001 5:05 PM

> ...do I need another spreadsheet application

Yep.