when we make excel sheet database we give some exiry dates in one column for some fields so when the expiry date comes, there should be a automatic alert message. So please let me know how to define this.
2007-03-08 02:08:13 · 3 answers · asked by nuzla97 1 in Computers & Internet ➔ Software
Use the Today() function as follows:
Assume you have expiry dates in col. C from C1 through C100.
In cell D1 enter the following formula:
=IF(TODAY()>=C1,"Expired","")
Copy and paste this formula to D2 through D100.
TODAY() is an Excel function that always returns today's date. So if today's date is greater than or equal to the expiry date, then D1 will display "Expired." Otherwise it will display a blank. Of course, you can change "Expired" to whatever alert message you want.
2007-03-08 09:39:38 · answer #1 · answered by Joliet Jake 3 · 0⤊ 0⤋
You could put an if statement in a new cell saying :=if(A1=to B1 or A1>B1,"OVERDUE","")
A1 is the orig data cell, B1 is the new reminder cell, OVERDUE is any message you want. I would choose to format this cell for: larger font, bold and select a red font color.
2007-03-08 03:09:59 · answer #2 · answered by Don R 5 · 0⤊ 0⤋
Use conditional format. Select the relevent column cell enter '=INT(A1)<=TODAY()'
2007-03-08 13:35:43 · answer #3 · answered by unnga 6 · 0⤊ 0⤋