Due Date Pop-up Alert in Excel | Date Due Tracker - Formula & Due Date Color Change Notifications

In this video I demonstrate three methods for tracking due dates.

1) Use a formula to display an in cell alert using the IF, AND and TODAY functions
2) Apply conditional formatting using a formula
3) Create a VBA pop-up alert that automatically appears when the workbook is opened

By clicking on this link you are helping to support this blog – thanks!
------------------------

[IvanCortinas_ES]

The use of conditional formatting with dates is always very useful. Excellent resolution with the macro. Thank you for this example Chester!

[Teambct]

This was incredibly helpful. Thank you!

[vasilikikladouchou]

Great video and very well explained! Thank you Chester.

[lestatuk]

Really great video, clear and concise... it helped me a lot... thank you so much

[fmi-immobilier]

Great and useful explainations ! Thank you !

[patrickschardt]

This has a little bit of everything. Nice work

[TareqAhmed]

I am really grateful for this video. It helped me to learn myself and applied for one of my clients.

[chaddrose]

Thank you! Exactly what I needed to make some progress.

[pinballwizard]

Thanks a lot! It is exactly what I've been trying to find since a very long time 😃👍

[louisepeedell]

Omg the vba is amazing just done my first one following this and impressed myself thank you

[jenpenj]

Thank you so much! That was brilliant and I learnt so much.

[BenDieselBasicAutomotive]

Thanks for the learning.... more power to you..

[anilkumark]

Thank you for the video, it's was very useful. It made my job easy to Following the Payment

[SergioMartinez-ukkt]

very useful, and thorough, it helps me a lot.
A question: how can be done the alerts coding if the information is in different sheets, i.e. a set of companies in different sheets, which the relevant information is showing in a summary page, depending of the drop down (i took it from other of your amazing videos).

[John-Titan]

This is a great tutorial, thank you. How can you stop the VBA based on text in another cell?

[Mahbub_L]

It's really cool. But is it possible when this workbook is in CLOSED mode at least a reminder email to send to the user of this file? So he'll open and send reminder to the customer if needed? Because an user may not open the workbook every day for such reason need this email reminder to user.

[CTTH]

Thanks for the video. Can you advise the code modification to break the results (INV1 INV3 INV4) displayed in the notification box on separate lines instead of inline? Thanks!

[CoolobiTj]

Excellent! Is it possible to run VBA not only for H2 but for each task? Because for some tasks "Bring Forward Reminder (days)" varies. In some tasks reminder should pop-up before 2 days for others 5, 10, 20 days.
Thanks again!

[ryqnztx]

Good morning Chester, Thank you for the video it has been so helpful for me but I was wondering if you could show me how to take column B and D and move it to a new tab to show a quick summary of upcoming and current due dates.

[ketransfer]

This is great. Thanks! Is it also possible to have this in hours instead of days? For instance, a pop-up 2 hours before a given time in a cell?