How do I set up alarms for expired dates in an excel spreadsheet?

B

bnp

In a spreadsheet containing dates, i'd like to set up some sort of
flag/alarm, that will pop up when the date is about to expire?
 
F

Frank Kabel

Hi
I would use conditional formating for this and a formula within this
dialog such as
=A1<TODAY()
 
B

Bob Phillips

To test for about to expire, use something like

=A1-5<TODAY()

for 5 days, or whatever number you want
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

alarm on a date cell? 2
alarm on a date cell 0
Filtering data from a pivot table to a graph 1
Flagging dates with conditional formatting 2
Expiration dates 7
How to set up alarm for cell has entry as date when it expires? 1
Use excel to calculate an expiration date 1
Macros Automatically Sort 3

Top