ExcelBanter - Suspense Notifications

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Suspense Notifications (https://www.excelbanter.com/excel-discussion-misc-queries/3674-suspense-notifications.html)

Tricky

Suspense Notifications

Can I set up an excell spreadsheet to notify me when a suspense goes overdue?

Dave Peterson

Maybe you could put a formula in an adjacent cell to the due date.

=IF(A1<TODAY(),"Overdue","ok")

Format it big, bold, red letters.

Tricky wrote:

Can I set up an excell spreadsheet to notify me when a suspense goes overdue?

--

Dave Peterson

All times are GMT +1. The time now is 01:58 PM.