Expiration Date Alerts with Conditional Formatting in Excel | Over Due, On time, Paid Out Highlight

Поділитися
Вставка
  • Опубліковано 11 січ 2025

КОМЕНТАРІ • 25

  • @telyvk8138
    @telyvk8138 3 місяці тому

    👏👏👏
    Excellent video. I had to slow it down a bit but you are so thorough and helpful. Thank you!

  • @highgarden4649
    @highgarden4649 5 місяців тому +2

    Thank you so much, very helpful and something I needed.

  • @padmavathit21
    @padmavathit21 9 місяців тому

    Thanks a lot. It's such a great video .

  • @propertytoinvestbymary5099
    @propertytoinvestbymary5099 9 місяців тому

    Thanks for sharing😊

  • @thebesttechnical3608
    @thebesttechnical3608 Місяць тому

    Thanks a lot. Enjoyed the Video while learning. It felt easy while learning.

  • @mdsiam9687
    @mdsiam9687 10 місяців тому

    Thanks for this awesome learning video!

    • @JopaExcel
      @JopaExcel  10 місяців тому

      Glad you enjoyed it! 🙏👍

  • @bhevsandalahao
    @bhevsandalahao 5 місяців тому

    Subscribing because I learned a lot in this channel. Thanks a lot!

  • @lagensca
    @lagensca 10 місяців тому

    Great video! thanks!

  • @BestDeal-zq5nd
    @BestDeal-zq5nd 6 місяців тому

    Thank you sooo much!! This helped me out

    • @JopaExcel
      @JopaExcel  6 місяців тому

      Glad it helped!🙏👍

  • @aslamsheikh600
    @aslamsheikh600 5 місяців тому

    Impressive demo

  • @mymoody6706
    @mymoody6706 3 місяці тому

    Thank you so much

  • @jordanoslyric
    @jordanoslyric Місяць тому

    Thanks

  • @lloydi0557
    @lloydi0557 10 місяців тому

    thank you

  • @keithmerrill4058
    @keithmerrill4058 2 місяці тому

    so far the today function is only subtracating 1 is there a way to take 2 off from Tuesday and 1 off of thurday for example I have 75 days left and on tuesday i want it to go to 73 and on thursdays I want it to minus 1 witch would equal 72 . Is there a way to do this?

  • @pinkch8874
    @pinkch8874 Рік тому

    Hi, great video. Just hope to ask, is it possible to make multiple rules for showing different alerts based on certain specifications?
    For example,
    Alert level for Brand A is 1 month
    For Brand B is 3 months
    and Brand C is 6 months
    Could we make it so that the formulae can detect which brand this product is referring to and quote the warning/alert in accordance with it?

    • @isabellegarvey230
      @isabellegarvey230 11 місяців тому

      What if the amount of due date days is 5 working days?

  • @vijaykumar2588
    @vijaykumar2588 4 місяці тому

    Your video is helpful but try to Show the whole page, row and column should be visible

  • @shikhatiwari725
    @shikhatiwari725 5 місяців тому

    In days of expiration I want to Exclude Saturday as well. How can I do this

  • @IzzyyRodriguez
    @IzzyyRodriguez 7 місяців тому

    Can this also be done on google sheets?

    • @JopaExcel
      @JopaExcel  7 місяців тому

      100%. However, the way to do it can change a bit. I will try to bring more videos about Google Sheets. 👍

  • @erisperdanaputra
    @erisperdanaputra 2 місяці тому

    Bagaimana Cara membuat excel dropdown, dengan kriteria HASIL = BOBOT (%) X SKALA (1-4). Contoh = Bobot 40% x Skala 2 = 40% x 2 = 80% hasilnya Cukup Sehat

  • @Sabrw_rites
    @Sabrw_rites 9 місяців тому +1

    Formula eror 😢

  • @guhomesconstructionllc1836
    @guhomesconstructionllc1836 2 місяці тому

    Can you make me one on Google sheet I can pay you.