How to Create Notifications or Reminders in Excel (5 Methods)

If you want to create notifications or reminders in Excel, you have come to the right place. Here, we will walk you through 5 easy methods to do the task smoothly.

Create Notifications or Reminders in Excel: 5 Simple Methods

In the following dataset, you can see the Product and Supply Date columns. Here, we have several Supply Dates that include dates that are ahead of the present-day, and past-day dates. Further, using this dataset, we will go through 5 easy methods to create notifications or reminders in Excel.

Here, we use Microsoft Excel 365. You can use any available Excel version.

1. Utilize Excel Conditional Formatting to Make Notification or Reminders

In this method, we will use the Conditional Formatting feature to create notifications or reminders in Excel. Using this method, we will mark the dates that are up to 30 days from today’s date.

Steps:

• First of all, select cells C5:C9.
• Here, you must select cells that you want to apply Conditional Formatting.
• After that, go to the Home tab >> select Conditional Formatting.
• This will bring out several Conditional Formatting options.
• Then, we will select New Rule.

• At this point, a New Formatting Rule dialog box will appear.
• Moreover, we will select Use a formula to determine which cells to format as the rule type.
• In addition, in the Format values where this formula is true box, we will type the following formula.

• This formula will find out the dates that are up to 30 days from today’s date.
• In addition, click on Format.

• Furthermore, click on Fill.
• In addition, select a color to format the cells.
• Here, we selected Yellow color.
• You can see the sample of the color.
• Then, click OK.

• Afterward, you can see the Preview of the color in the New Formatting Rule dialog box.
• In addition, click OK.

• As a result, you can see the dates that are up to 30 days from today’s date have been marked with Yellow color.
• Therefore, we can create notifications or reminders for supply dates.

2. Combine IF and TODAY Functions to Generate Notifications

In this method, we will use the combination of IF and TODAY functions to create notifications or due date reminders in Excel. Using this method, we will find out notifications for the dates that are less than today.

Steps:

• In the first place, we will type the following formula in cell D5.

• After that, press ENTER.
• Therefore, you can see the result in cell D5.
• At this point, we will drag down the formula with a Fill Handle tool.

• Therefore, you can see the notifications or reminders for the dates that are less than today’s date.

Read More: How to Set Due Date Reminder Formula in Excel

3. Merge IF, TODAY, and AND Functions to Create Reminders in Excel

In this method, we will merge IF, TODAY, and AND functions to create notifications or reminders in Excel. Here, we want notification or reminder No for the dates that are ahead of today and Yes for the dates that are behind today.

Steps:

• In the beginning, we will type the following formula in cell D5.

• After that, press ENTER.
• Hence, you can see the result in cell D5.
• Furthermore, we will drag down the formula with the Fill Handle tool.

• Hence, you can see the notification or reminder No for the dates that are ahead of today and Yes for the dates that are behind today.

4. Apply Excel VBA Macros to Get Pop-Up Notification or Reminders

In this method, we will use VBA to create pop-up notifications or reminders in Excel.

Steps:

• In the first place, we will right-click on the Sheet name >> select Visual Basic.
• Here, we will right-click on the Sheet in which we want the notification to pop up.

• At this point, a VBA Editor window will appear.
• Furthermore, we will type the following code in the VBA Editor window.

Sub Reminder_date()
Dim date_col As Range
Dim due_date As Range
Dim pop_up_reminders As String
Set date_col = Range("D5:D9")
For Each due_date In date_col
    If due_date <> "" And Date >= due_date - Range("D11") Then
        pop_up_reminders = pop_up_reminders & " " & due_date.Offset(0, -2)
    End If
Next due_date
If pop_up_reminders = "" Then
    MsgBox "do not go for today"
Else: MsgBox "Contact these buyers " & pop_up_reminders
End If
End Sub

• After that, Save the code >> Run the code.
• Therefore, you can see the pop-up notification in the Worksheet.

5. Add New Ribbon and Insert VBA to Obtain Notifications in Excel

In this method, first, we will insert VBA, and then, we will create a customized ribbon to assign the VBA. Afterward, every time we click on the customized ribbon, a reminder will pop up.

Let’s go through the following steps to do the task.

Step-1: Insert VBA

• In this step, we will insert VBA.
• To do so, in the first place, go to the Developer tab >> select Visual Basic.
• This will open the VBA Editor window.
• Here, you can press the ALT+F11 keys to open the VBA Editor window.

• At this point, from the Insert tab >> select Module.

• Moreover, we will type the following code in the Module.

Dim time As Double
Dim message As String
Sub Pop_up_Notifications()
Dim what_time As String
If time = 0 Then
what_time = InputBox("when you want the reminder to Popup?")
If what_time <> "" And what_time <> "False" Then
message = InputBox("enter notification message")
On Error Resume Next
time = Date + TimeValue(what_time)
On Error GoTo 0
Application.OnTime Alarm, "Pop_up_Notifications"
End If
Else
Beep
Application.Speech.Speak message
MsgBox message
message = " "
time = 0
End If
End Sub

• After that Save the code >> go back to the Worksheet.

Step-2: Add Customized Ribbon

In this step, we will add a customized ribbon to the Worksheet. Here, we want the customized ribbon in the View tab, beside the Macro group.

• To do so, first, go to the File tab.

• After that, from More >> select Options.

• At this point, an Excel Options dialog box will appear.
• Then, from the Customize Ribbon >> go to the View tab >> expand the View tab.
• Furthermore, select Macros >> click on New Group.

• Therefore, you can see a New Group under the Macro group.
• Next, we will rename this New Group.
• To do so, we will click on Rename.
• At this point, a Rename dialog box will appear.
• Then, we will type Notifications in the Display Name box >> click OK.

• Now, it is time to assign the macro to the new Notification ribbon.
• Then, we will click on the drop-down icon in the Choose commands from box >> select Macros.

• Then, we will select Pop_up_Notification which is the Sub of our code.
• Click on Add >> select Rename.

• Then, we will select a Symbol to show the ribbon.
• Here, we select a Hand symbol.
• You can select any symbol according to your wish.
• In addition, click OK.

• Therefore, you can see a Pop_up_Notifications ribbon in the View tab.
• Furthermore, we will click on Pop_up_Notifications.

• After that, an Input box will appear.
• Here, we will input a time at which we want the notification >> click OK.

• Along with that, another message box will appear.
• Then, we will type the message >> click OK.

• Therefore, when the time of message comes, it pops up the message.
• Along with that, you will hear an audio of the message.
• Hence, we can create notifications or reminders in Excel.

Practice Section

You can download the following Excel file and practice the explained methods.

Download Workbook

You can download the following Excel file and practice while reading this article.

Conclusion

Here, we show you 5 easy methods to create notifications or remainder in Excel. Thank you for reading this article. We hope it was helpful. If you have any queries, please let us know in the comment section.

Related Articles

• How to Generate Automatic Email Alerts in Excel
• How to Create Alerts in Excel
• How to Disable Alerts in Excel VBA

<< Go Back to Alerts in Excel | Learn Excel