View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Rich
 
Posts: n/a
Default Setting notification of dates in Excel

assume the pass date is in row b,,,, you could but the now function in row c
and use conditional formating to hightlight the date when it is less than 2
months away

"Needing help in Guam" wrote:

How do I setup a notification that a date of expiration is 2 months away in a
spreadsheet. I want the spreadsheet to automatically highlight if the person
is about to expire with a qualification date. Is this possible and how do I
achieve this goal?

Thanks for any help!