excel macro? expiration reminders

[karlb65]

I am writing this for a friend. He works in the business office of
real estate company. He has a spreadsheet that contains listings an
their expiration dates, and wants to be able to to have excel remin
him so many days before the listing expires (and up to so many after i
case he is not working the day a listing expires so it can remind hi
later). Is there a way, perhaps a macro that pops up a window t
remind, or some way to do this? Hopefully this is enough info but ca
provide more if necessary.

K

 

[Don]

Hi KB,

Although not too familiar with this function I believe
conditional formatting should do the job for him. i.e.
change the cell color to an alert color.

Don