ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Notification based on Date (https://www.excelbanter.com/excel-worksheet-functions/8626-notification-based-date.html)

Andi

Notification based on Date
 
I have a (rather large) .xls that contains information including Name, Date,
Amount, among other things. I would like to receive notice requiring action
90 days from the date entrered on the spreadsheet - is there a way in Excel
(or Access) to do this? Thanks.

Frank Kabel

Hi
what kind of notification do you want. Highlighted cell/row?. If yes you may
use 'Format - Conditional Format' for this

--
Regards
Frank Kabel
Frankfurt, Germany
"Andi" schrieb im Newsbeitrag
...
I have a (rather large) .xls that contains information including Name,
Date,
Amount, among other things. I would like to receive notice requiring
action
90 days from the date entrered on the spreadsheet - is there a way in
Excel
(or Access) to do this? Thanks.




Andi

Thank you Frank - what I was hoping for was some sort of email notification?
If not, I can use the highlighted Row option. Thanks again.

"Frank Kabel" wrote:

Hi
what kind of notification do you want. Highlighted cell/row?. If yes you may
use 'Format - Conditional Format' for this

--
Regards
Frank Kabel
Frankfurt, Germany
"Andi" schrieb im Newsbeitrag
...
I have a (rather large) .xls that contains information including Name,
Date,
Amount, among other things. I would like to receive notice requiring
action
90 days from the date entrered on the spreadsheet - is there a way in
Excel
(or Access) to do this? Thanks.






All times are GMT +1. The time now is 07:06 PM.

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