date reminder

[putlog]

I have a worksheet that is employees names down the first colum and training course names across the top row, with expiry dates in the cells. What i would like to do is 30 days before traing needs updating a message or something to remind me to book a place for them. Is this possible in excel or do I need to create an access database? I should ad that I only have a very basic knowledge of excel.

Thanks for any help
Ray


--------------= Posted using GrabIt =----------------
------= Binary Usenet downloading made easy =---------
-= Get GrabIt for free from http://www.shemes.com/ =-

 

[Pete_UK]

Highlight all the cells that contain the expiry dates (assume this is
B2:M50), such that B2 is the activecell, then click on Format |
Conditional Formatting, and in the panel that pops up select Formula
Is rather than Cell Value Is. In the next box enter this formula:

=B2-TODAY()<=30

Click the Format button in the panel, click on the Patterns tab (for
background colours) and choose a colour (eg bright yellow). Then click
OK twice. Now if you have any dates that are within 30 days of today's
date, the background colour will show as bright yellow. Not quite the
same as giving you a message, but effective nonetheless.

Hope this helps.

Pete