can you create alerts to notify you when somethng "expires" in a .

T

tpen

I keep a data base which has a list of when certian things expire. Can you
create alerts to notify you when the expiration is approaching or when they
have expired.
 
A

Alan

Conditional formatting is good for this sort of thing, look it up in Help to
make the cell with the date in it turn yellow when expiry is 2 weeks away,
red when one week away or whatever,
Regards,
 
S

Sunil Jayakumar

Hi,

The easiest way would be to run a query on the database, match expiry date
against current date (use the Today() function), and use conditional
formatting to highlight any expired products.

I'd be glad to help out more if you could give me some more information.

Hope this helps

Sunil Jayakumar

tpen said:
I keep a data base which has a list of when certian things expire. Can you
create alerts to notify you when the expiration is approaching or when
they
have expired.
Click to expand...

www.ayyoo.com/loans.html
 
J

JulieD

Hi

the easiest way to achieve this IMHO is via conditional formatting (of
course, you'll only see it when you open the workbook)
basically, say your dates start in cell G2 and go down the column and you
want to be advised if the expiry date falls in the next 15 days
select the dates, ensuring that row 2 is at the top of the screen
format / conditional formatting
choose
formula is
type
=AND($G2<=TODAY()+15,$G2>=TODAY())
click on the format button - choose a format (cell background colour is
under patterns)
click OK twice
 
Top