How to Create Notifications or Reminders Automatically in Excel

Home More Excel (VBA) Training Videos


You can create reminders or notifications in MS Excel using 3 methods quickly and easily:
1. Use the IF function to display a message
=IF(B2<TODAY()+3,"Send Reminder","")

2. Use conditional formatting
  • Click on Home Tab
  • In the Styles command group select conditional formatting tab
  • Click on New Rule...
  • In the new formatting rule window select 'Use a formula to determine which cells to format'
  • Under the 'Format values where this formula is true:' write the formula given below
  • =AND(C2<>"",C2<TODAY()+3)
  • Next click on Format and apply the formatting of the cell and font of your choice
3. Use Excel VBA witha 'for loop'. The macro code is given below:
Private Sub Workbook_Open()
For Each cell In Range("B2:B100")
If cell.Value < Date + 3 And cell.Value <> "" Then
cell.Interior.ColorIndex = 3
cell.Font.ColorIndex = 2
cell.Font.Bold = True
End If
Next
End Sub

You can also intialize the formatting in the macro code above with the following line of code under 'Private Sub Workbook_Open()':
Range("B2:B100").Interior.ColorIndex = xlNone

Watch the Excel training video below to see how all the three methods have been implemented:



Watch the video on youtube