How to Create Notifications or Reminders Automatically in Excel

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


  • Next click on Format and apply the formatting of the cell and font of your choice

3. Use Excel VBA with a ‘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
End Sub

You can also initialize 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:

35 thoughts on “How to Create Notifications or Reminders Automatically in Excel

  1. I’ve gone thru your above video 3 times. I have found some discrepancies as said below

    1. In con . form you are using a formula =AND(B2**, B2<TODAY()+3 – pls. confirm whether it is ** or "'
    2. When it is finished the auto teller says there is a mistake in the formula. If you are staring with = AND, it is advising to use '=AND
    3. You have advised for cells B2 and then manage it for Cell C2. If I have to use it for some more cells which may be not less than 100 nos. of cells how should I write the formula?

    Please guide me. Thank u

    Truly yours,

    L. N. Rayan

      1. Dear sir ,
        Thank you so much form your video.
        i did creat an Excel sheet and should i put reminder ,many times i did try ,but it dosnt take the fomulla ,it shows some eroors , can you help me , if its posseble can i send you my excell shet

  2. Hi Sir Dinesh,

    I am going to create an auto email notification in excel 2010 using google. the excel file is currently uploaded to the google drive / google sheets and if I am going to change the status of the person handling ticket their is an automatically email notification to the processor of the ticket. Our company is using google email. You example was outlook so thier a problem in terms of code you’ve provided.


    Regards Arcane

  3. Respected Sir,
    I like all of ur tutorial and I learn a lot from the same

    Actually I am unable to send the value of the cells

    as per ur example the Credit card No. xxxxxxxxx and the date xxxxxx

    like I want to send subject as

    Dear Sir

    ” Your credit card number xxxxxxxxxxx is expiring on Dated xxxxxx. ”

    Please help me……….

    Thanks in advance

  4. Hello!

    Your video is very helpful. I watched your other one where you can use a macro to send reminder emails. For some reason no e-mail is sending, do I need to do something with outlook? Currently I click on macro > Run and nothing.

    Thank you!

  5. Dears, I need the auto reminder to be send whenever I starting / logging on to my PC without opening the excel file. can you please help me please thank you. Is this possible?

  6. Dear Sir,

    Thank you for your video. It was very helpful but I have question. The formula keeps on looping even the limit exceeds. for example: today is 04(april)/8/2013 and the due date is 04/7/2015, though the date has crossed due date it still shows “send notification”. Please clarify with this error.

    Thank you very much. really appreciate your help.

    best regards,

  7. Dear sir,
    can we make events stored in excel sheet to popup on the pc screen(as alarm) even-though the excel sheet is not opened for ex: iam maintaining an excel sheet for monitoring the due dates of instruments for calibration. cant i make the due date of particular instrument to popup on the pc screen eventhough the excel sheet is not opened

    thank you

  8. Hello!
    I’m working a multinational company where i have very big excel chart where I need to work every minutes,
    My problem is I’m sending some package to other country and I need to push them just after 3,6 & 10 Days from sending date based on country, I would like you to help me, like, The col color would become YELLOW if the parcel sent already 3 Days, The column color would become PINK if it’s 6 days over and finally the column should have RED if it’s touch 10 Days,
    For your information I’m entering all the data in same column,

    So that i can push them based on the column color (I don’t need to search for individual).

    Hope someone will help me,
    Thanks in advance
    Sahriar Hassan Riaz

  9. We run a Cleaning Business and have got a spreadsheet with a column for the inspection months and what day of month is set for that site. Is there a way to have reminder system in the spreadsheet. The inspection column has values as “1 Jan Mar Jul Oct Dec” or “3 Month”. Is there a way that the spreadsheet creates reminders on 1st day of the months mentioned above? Please help.

  10. I just Found this Site! I need these functions but I can not get them to work. I tried IF and VBM.
    IF returns #NAME? and VBM returns Expected : list seperator or )

    I did cut and paste on both. My sheet is very simple, only had to change your range from b2 to b5

  11. SIR

  12. how to make a Automatic Pop-up message for MS Excel even the application is closed, I’ve already using the Automatic Pop-up message when you start the Excel

  13. Hello Sir,

    Every thing is fine, I am unable to under stand the +3 scenario . What I am looking for is I want a notification on daily basic, Suppose today date is 22 May 2017 when I open my Excel sheet today what ever task assigned on current date that need to be highlight with color , This means any how I need to do work on that task

    Do let me know as current formula is not working in my case


  14. As I am a new user of Excel for professional the purpose, I have learned new things every day from different blogs. can you tell me what is Jax-rs and what are the benefits if I download excel from it? Otherwise, I have to take help of ms excel customer support number to understand what it is.

  15. This worked great for me! What if I would like to do something like set an alert for a due date a year out and have it display 7 days prior to the due date?

  16. i have unable to set a formula regarding to alert before due date notification on daily base.
    Please help us, how to make a Automatic Pop-up message for MS Excel when the application will open. MS Excel sheet give automatic pop-up 7days before due date.
    If need excel file, i will also share file.

  17. i have unable to set a formula regarding to alert before due date notification on daily base.
    Please help us, how to make a Automatic Pop-up message for MS Excel when the application will open. MS Excel sheet give automatic pop-up 7days before due date.
    If need excel file, i will also share file.

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.