ExcelBanter - Reminder

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Reminder (https://www.excelbanter.com/excel-discussion-misc-queries/159426-reminder.html)

I have put our subscription in excel. I have a column for the description
and a column for the price and column for the month the subscription is due.
Is their any way that I can set a reminder to let me know when the
subscription is due? I am using excel 2000

Assuming Date in column C; in D1 enter
=IF(C1<TODAY(),"Overdue",IF(C1-TODAY()<30,"Due",""))

Also consider using Format | Conditional Formatting to colour the row red
when overdue and blue when due. Select all the data; use Conditional
Formatting with
Formula Is: =$D1="Overdue", then format patter/fill to red
add another for "Due"

best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"horseman" wrote in message
...
I have put our subscription in excel. I have a column for the description
and a column for the price and column for the month the subscription is
due.
Is their any way that I can set a reminder to let me know when the
subscription is due? I am using excel 2000