How to Create Notifications or Reminders in Excel

แชร์
ฝัง

ความคิดเห็น • 75

  • @pythonprog7047
    @pythonprog7047 3 ปีที่แล้ว +68

    Notification and Highlight are different things!

    • @haziqfirdaus4956
      @haziqfirdaus4956 3 ปีที่แล้ว +4

      I know right! The title is misleading

    • @fantasyteamshorts6112
      @fantasyteamshorts6112 ปีที่แล้ว +2

      Absolutely

    • @ArcusDraco
      @ArcusDraco 26 วันที่ผ่านมา +1

      It's that way because Excel doesn't have a way to send actual notifications sadly. This was helpful for me, but it's not ideal.

  • @whatcoloristhematrix2209
    @whatcoloristhematrix2209 2 ปีที่แล้ว +3

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

  • @SofiyaGaripova
    @SofiyaGaripova 3 ปีที่แล้ว +4

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

  • @EmanuelaBuonamici
    @EmanuelaBuonamici 4 ปีที่แล้ว +9

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

    • @ConsulthinkProgrammer
      @ConsulthinkProgrammer 4 ปีที่แล้ว

      Try this for an alternative in google sheets:
      Reminder System | Google Sheets | Conditional Formatting | Apps Script | Email Notification
      th-cam.com/video/UZ9112PoBMQ/w-d-xo.html

  • @mrbumble1635
    @mrbumble1635 5 ปีที่แล้ว +6

    Is there any way of creating a kind of separate "summary" sheet to show lets say expired and expiring in

    • @Mar10la
      @Mar10la 4 ปีที่แล้ว +2

      Hi, have you figured out a way for this yet? I'm looking, but haven't found an answer

    • @shivanimahida5544
      @shivanimahida5544 3 ปีที่แล้ว

      I know u just need a filter

    • @shivanimahida5544
      @shivanimahida5544 3 ปีที่แล้ว

      U need to filter

  • @roxanevanwest-charles3863
    @roxanevanwest-charles3863 2 ปีที่แล้ว +2

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

  • @charlieaffourtit449
    @charlieaffourtit449 4 ปีที่แล้ว +2

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

  • @bhthllj
    @bhthllj 4 ปีที่แล้ว +16

    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

    • @MUHAMMADSaadKhan730
      @MUHAMMADSaadKhan730 4 ปีที่แล้ว +1

      @Himanshu Jha Hi guys, Please let me know if you find something that notifies with an alert! Thanks

    • @ConsulthinkProgrammer
      @ConsulthinkProgrammer 4 ปีที่แล้ว

      Try this for an alternative in google sheets
      Reminder System | Google Sheets | Conditional Formatting | Apps Script | Email Notification
      th-cam.com/video/UZ9112PoBMQ/w-d-xo.html

  • @Hynessiiee52
    @Hynessiiee52 ปีที่แล้ว

    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?

  • @Midnightservant1
    @Midnightservant1 2 ปีที่แล้ว

    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

  • @princemjprasanth8954
    @princemjprasanth8954 3 ปีที่แล้ว

    Thanks for the helpful info bro.

  • @richardbelliveau8881
    @richardbelliveau8881 2 ปีที่แล้ว +1

    How do it for the whole column?

  • @MalindaKruger15
    @MalindaKruger15 ปีที่แล้ว

    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

  • @nicoletta.o
    @nicoletta.o 3 ปีที่แล้ว +1

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

  • @shaileshtamhankar4620
    @shaileshtamhankar4620 ปีที่แล้ว

    THANKS, IT IS REALLY HELPFULL

  • @samuelmckinnon541
    @samuelmckinnon541 4 ปีที่แล้ว +4

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

  • @obedankomah7904
    @obedankomah7904 ปีที่แล้ว

    Thanks for saving me

  • @irtazaansari-py8ph
    @irtazaansari-py8ph ปีที่แล้ว

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

  • @sandipvakude2
    @sandipvakude2 ปีที่แล้ว

    Well explained

  • @richardbelliveau8881
    @richardbelliveau8881 2 ปีที่แล้ว

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

  • @smtammyl
    @smtammyl 3 ปีที่แล้ว +1

    How do I make it to show past due dates highlighted? What would that formula be?

    • @egleliin8551
      @egleliin8551 2 ปีที่แล้ว

      It should be the same as the last formula, but istead of +4, it should be -4

  • @tatohej
    @tatohej 3 ปีที่แล้ว +1

    Doesnt work form me keeps poping out msg an keeps askig if I am trying to write ruel and suggesting to start with apostrophe......

    • @thembalethumafaka440
      @thembalethumafaka440 2 ปีที่แล้ว +1

      instead of using a comma to apply the second logical use this ;

  • @mikeav7083
    @mikeav7083 3 ปีที่แล้ว

    Great Tips! Thanks!!

  • @DrippySneakerz
    @DrippySneakerz 3 ปีที่แล้ว +2

    It doesn't work. I've gone through this video numerous times now and nothing changes. What am I missing?

    • @kerjasampinganku
      @kerjasampinganku 3 ปีที่แล้ว

      I found this useful, may can relate: Create an Event Reminder use Color | Status: Finish; Today; Three Days Until 1 Day Before Event th-cam.com/video/7FdByf2TEo0/w-d-xo.html

  • @listeneverywhere989
    @listeneverywhere989 5 ปีที่แล้ว +3

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

    • @littermonkey
      @littermonkey 4 ปีที่แล้ว +3

      in the second formulation, you could adjust the date you desired by replace '4' to your prefer date

  • @ToolRoom-o3h
    @ToolRoom-o3h 8 หลายเดือนก่อน

    IDK why but all these formulas never work on my work pc very frustrating. always the same error: There is a problem with this formula, not trying to type a formula? etc...

  • @sinfor70
    @sinfor70 4 ปีที่แล้ว +2

    Sir how about if I want how many staff has expired certificates?

    • @NOREFABY
      @NOREFABY 4 ปีที่แล้ว +1

      If you find the answer, could you share? That is exactly what I need to do as well.

    • @shivanimahida5544
      @shivanimahida5544 3 ปีที่แล้ว

      @@NOREFABY I know the answer

  • @katspajamaz
    @katspajamaz 5 ปีที่แล้ว +4

    how do i apply this rule to an entire column

    • @Jon_Light
      @Jon_Light 4 ปีที่แล้ว

      click the cell > hold ctrl + drag the cell downwards until whichever cell you want to apply the rule.

  • @awajispraise9556
    @awajispraise9556 3 ปีที่แล้ว

    where is the link to copy the code for POP-UP?

  • @juanflorez1644
    @juanflorez1644 3 ปีที่แล้ว

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

  • @2007lejin
    @2007lejin 2 ปีที่แล้ว

    You didn't mention about the alert message formula

  • @garydsouza2335
    @garydsouza2335 3 ปีที่แล้ว

    hi is it possible to add a sound notification

  • @snipeyspidey24
    @snipeyspidey24 5 ปีที่แล้ว

    Awesome and very helpful video. Could you do the exact demonstration but for Google Sheets? Can Google Sheets not even have color coated "reminders"?

    • @howtechoffice
      @howtechoffice  5 ปีที่แล้ว

      Thanks for the idea!

    • @curlybham8325
      @curlybham8325 ปีที่แล้ว

      Google sheet i try not work, do u ?

  • @premytc797
    @premytc797 4 ปีที่แล้ว +3

    i need desktop notification with excel. is this possible?

  • @playnation9472
    @playnation9472 4 ปีที่แล้ว +1

    Please help it is not working

  • @saharjoorabchian307
    @saharjoorabchian307 2 ปีที่แล้ว

    thnx really helped

  • @Know_Allah
    @Know_Allah 4 ปีที่แล้ว

    The window of "new formatting rule" is very small in the video,I couldn't see what you are writing..

    • @kerjasampinganku
      @kerjasampinganku 3 ปีที่แล้ว

      I found this useful th-cam.com/video/7FdByf2TEo0/w-d-xo.html

  • @iftikharhafeez1742
    @iftikharhafeez1742 3 ปีที่แล้ว

    I tried it but its not showing any results

  • @fahdaljibali6018
    @fahdaljibali6018 2 ปีที่แล้ว

    Great job thank you 🙏

  • @harrinarayan2079
    @harrinarayan2079 ปีที่แล้ว

    Where are the reminders and Notifications? Is there a way to get Excel to give notifications and reminders without having to manually open Excel? Notify me so I can open Excel and see what is in alarm

  • @ijustdontlikeyou1427
    @ijustdontlikeyou1427 4 ปีที่แล้ว +2

    Today is 6/26
    Yeah we're on the same day but a year later 😄

  • @ismartshankarjaiswal
    @ismartshankarjaiswal 4 ปีที่แล้ว

    nice video man

  • @kalyang1769
    @kalyang1769 4 ปีที่แล้ว

    How to connect phone reminder to excel

  • @EmreDagli01
    @EmreDagli01 4 ปีที่แล้ว +2

    it is not a reminder or notifications

    • @kerjasampinganku
      @kerjasampinganku 3 ปีที่แล้ว

      This is the real one: Reminder via email from your Google Sheets data th-cam.com/video/UZ9112PoBMQ/w-d-xo.html

  • @littermonkey
    @littermonkey 4 ปีที่แล้ว

    This trick was saving my day, thank you
    :)

  • @mmmm-xm5fc
    @mmmm-xm5fc 2 ปีที่แล้ว

    This formula not working

  • @jenniayan6731
    @jenniayan6731 5 ปีที่แล้ว

    Picture is so small

  • @fire-works
    @fire-works 10 หลายเดือนก่อน

    This does not do Notifications or Reminders! This is just highlighting cells!

  • @qrsimon
    @qrsimon 2 ปีที่แล้ว

    Hi buddy

  • @robhmaab
    @robhmaab ปีที่แล้ว

    Such a misleading title. Highlighting is different than sending notification!

  • @ShashiMGKumar
    @ShashiMGKumar 2 หลายเดือนก่อน

    You wasted my time with your misleading title. Absolute waste!

  • @tanzeel2006
    @tanzeel2006 3 ปีที่แล้ว

    Just wasted my four min and 36 sec