ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Setting notification of dates in Excel (https://www.excelbanter.com/excel-discussion-misc-queries/69497-re-setting-notification-dates-excel.html)

Rich

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!



All times are GMT +1. The time now is 07:45 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com