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
 
Top