 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / General Excel Questions / September 2007Reminder
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  SignatureBernard V Liengme Microsoft Excel MVP www.stfx.ca/people/bliengme remove caps from email >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 |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.