How to Create Notifications or Reminders in Excel

Use a formula to determine highlighted dates.
There are a number of ways to set this up, but the best way is to use Conditional Formatting to create a notification based on Today’s date.

1.    Select the column or range of cells that will have dates. Click Conditional Formatting and then create a New Rule.

2.    Choose “Use a formula to determine which cells to format”. In the “Format values where this formula is true”, type in (watch the video!). To format cells that contain today’s date. Replace D8 with the first cell in your range. After typing in the formula, click the Format button and change the text however you want it to look like.

3.    If you want a notification three, ten, etc. days ahead of time use this formula: (watch the video!). Replace the “+4” with however many days of “ahead time” you would like, and add 1 to it because of the less than sign.

❓ What dates do you need to keep track of? Please let us know in comments.

#HowTech #MicrosoftExcel

--------------------------------------------------------------------------------------------------------------

[pythonprog]

Notification and Highlight are different things!

[SofiyaGaripova]

It is a really useful thing for you to create notifications and reminders in Excel! Thank you!

[whatcoloristhematrix]

Can this be setup to send a email or text message reminder for the date range?

[roxanevanwest-charles]

The older I get the more I feel the need for this reminder feature, thanks a million.

[EmanuelaBuonamici]

This is great! How would we modify the formula if we wanted a reminder that would last 2 whole weeks before the Due Date?

[juanflorez]

Perfect. Thank you for showing this very simple to follow how to video

[charlieaffourtit]

Hi, Are you able to make reminders only counts business days? For Office 365 for MAC

[mrbumble]

Is there any way of creating a kind of separate "summary" sheet to show lets say expired and expiring in <3 days? I have conditional formatting for my big data sets which works great but what if I just wanted a quick view of the expired and expiring soon items on a separate sheet which auto-populates. Is it possible?

[bhthllj]

While the video was quite helpful, the title of the clip is somewhat misleading. I was searching for a solution to notify (as in e-mail notification) when something's changed, all other results were topical except this one.
Keep it up, though! Cheers

[samuelmckinnon]

How do I make my conditional formatting for the due date and anything past it? and copy that to all cells below?

[littermonkey]

This trick was saving my day, thank you
:)

[MalindaKruger]

Please help me, i want to set up a program to ensure me that i can see every day when a driver licence or pdp expired how can i done this in excell

[Midnightservant]

how to make this reminder recurrent every X amount of days, like for example every 25 days i want this to show the orange color for one whole day for example. Thank you

[listeneverywhere]

how about i need to notify a month before sir? thank you

[katspajamaz]

how do i apply this rule to an entire column

[irtazaansari-pyph]

i want my execl reminds me the due date via whatsapp notification is it possible ??

[nicoletta.o]

its not working in my side . i enter the formula but keep getting an error message which doesn't recognize it as a formula

[Hynessiiee]

Can i set rules for columns for example every 90 days my gas detector needs calibrating. So 2 weeks out the columns would go yellow then the date it's due and beyond it's red?

[garydsouza]

hi is it possible to add a sound notification

[richardbelliveau]

I am trying to do this, but need to set it for a year and, 3 yrs, etc.