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!
|