How do I create an alert of expiration date in Excel?
I created a spreadsheet to track documents. The last column is for
expiration dates of documents. How can I set up an alert when the expiration date is approaching? |
Use conditional formatting in the cell. For example, with the date in A12,
something like Formula is =TODAY()+7=$A$12 as the condition. Then choose a pattern. "kachnycz" wrote: I created a spreadsheet to track documents. The last column is for expiration dates of documents. How can I set up an alert when the expiration date is approaching? |
All times are GMT +1. The time now is 12:16 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com