Forum Discussion
lrivera822
May 28, 2018Copper Contributor
Help with an excel formula
I want to receive an alert when a document lacks 30 days to expire and that continue to indicate it during those 30 days. If C9 is greater than -30 but less than 0 is about to expire.
Haytham Amairah
May 29, 2018Silver Contributor
Hi,
I got two solutions for you!
First one by using a formula, and the second by using VBA.
The formula solution will notify you in another cell on the same worksheet by displaying the notification text in the cell.
But the second solution will notify you each time you open the workbook and display a message box when the document is about to expire or expired!
Please find the attached files.
Hope that helps
Haytham