Excel 2007's new Date feature lets you see at a glance which accounts or projects are coming due each time you open your worksheet. For example, say you have a list of financial accounts and their dates of renewal (Figure A).
A collection of free Excel templates for businesses that will help you perform your job faster and in an efficient way. Free Excel Templates Expiration Reminder Toggle navigation. I have specific tasks due on specific dates so I'm basically looking for a pop up reminder for it to search multiple sheets under specific columns within each sheet and if that column equals todays date to generate a pop up reminder stating a task that is listed two cells over from the date column.
Figure A
At the end of each month, you check your sheet to see which accounts are coming up for renewal next month. Follow these steps:
- Select the range of cells that contains the Renewal dates .
- On the Home tab, click Conditional Formatting.
- Point to Highlight Cell Rules and then click A Date Occurring (Figure B).
Figure B
![Excel Sheet With Reminder Excel Sheet With Reminder](/uploads/1/2/5/2/125263522/680155043.png)
- Click the drop-down arrow, select Next Month (Figure C), and click OK.
Figure C
The accounts up for renewal next month are highlighted in red. Note that Excel automatically updates the rule based on the system clock; so when you open the workbook a month from now, Excel formats new dates based on the rule's conditions.
Miss an Excel tip?
![Paper Paper](/uploads/1/2/5/2/125263522/164929366.jpg)
Check out the Microsoft Excel archive and catch up on other Excel tips.
Help users increase productivity by automatically signing up for TechRepublic's free Microsoft Office Suite newsletter, featuring Word, Excel, and Access tips, delivered each Wednesday.