Highlight Overdue and Expiring Business Days | Conditional formatting in Excel | Excel Tutorial

Поділитися
Вставка
  • Опубліковано 23 гру 2024

КОМЕНТАРІ • 84

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

    Thank you! Can I add I new column to tick off any completed dates, removing the red highlight?

  • @PENELOPEPOWELL-d1m
    @PENELOPEPOWELL-d1m Місяць тому

    this was great for what I wanted. Can you just clarify what formula you would need to change the highlighted cells that had since been completed so that they showed as done. Thanks

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

    Can you automatically set yearly reminder due from the start date? I need to make a list that will automatically change yearly. Is this possible or do I have to change the due date year all the time? I hope I make sense.

  • @triciapena9080
    @triciapena9080 2 роки тому +1

    I have looked all over for exactly this video, Thank you!!!!! A little quick but precise.

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

    if the due dates is not a fixed date for all the rows, then ? if every case number had a different due date in column C then what would be the formula ?

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

    Hey, I have 2 colums. Colum C is the date of the test i did. Colum D is the due date in 3 months time. How do i create rules so within from day test was done to 1 month away from due date the colum is green. 1 month to 1 day before due date it is yellow then the date the new test is due and beyond it is red? Colum D is set up as =EDATE(C2,3) So I only ever need to input the new date i've done a test.

  • @duncanlingrueyshan7199
    @duncanlingrueyshan7199 2 роки тому

    Hi, may i ask how to set the weekends to count saturday on the weekends ? because my company work on sat on the first and third week

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

    Thank you - you have presented in a way that I can understand.

  • @cailinanne
    @cailinanne 4 роки тому +1

    Ugh. It took me like 30 minutes to teach this to myself! haha, wish I had found you sooner!

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

    Question. So if I put today's date in 1-6-2023 will the sheet automatically turn that text red on 1-11-2023 because it's been five days?

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

    Can you nest these functions?

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

    This worked for what I needed!

  • @rodneygarrard1
    @rodneygarrard1 2 роки тому

    very good introduction for me. I have been mucking around with the today function without much success, Thanks

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

    Can you tell me how I can get reminders from excel to my outlook ?

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

    Quick and good information.

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

    This was very helpful. Thaks for taking the time to share!

  • @mariafebusgano8870
    @mariafebusgano8870 2 роки тому

    is it applicable to google sheets too?

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

    Thank you! Solved what I wanted to do for dates occurring within one week of Today()! ;)

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

    Great Video, Thanks

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

    Thank you! That Today() function is really powerful

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

    Thank you so much! Great Job!

  • @ultraniusmaximus1536
    @ultraniusmaximus1536 4 роки тому

    Thanks for this video! Ok, so more questions for you...
    I'm familiar with the today() function by adding or subtracting days from today, but what I'd like to know is how to show expiring dates in the future (e.g. 3 months, 2 years and so on)? Also, how would I apply that to multiple, non-consecutive columns in a worksheet? I've tried using absolute, such as $B$4, but when I go to apply that to multiple columns like I described above, it keeps using that cell's specific date and not the date of the other cells I want it to effect.
    And last question (promise!): is there a way to have some kind of notification such as a pop-up window when a certain date has expired, or is expiring very soon (aside from just colors)?

    • @whyworksmarternotharder
      @whyworksmarternotharder  4 роки тому

      I don’t believe there is a way other than through VBA he would be able to create a pop up. You can however use conditional formatting based on the values in another cell. I have a video on that as well. Not 100% sure I understand your question.

    • @ultraniusmaximus1536
      @ultraniusmaximus1536 4 роки тому

      @@whyworksmarternotharder Hi. I guess I was making the question more confusing than it needed to be, sorry. The closest formula I could find that I 'think' I was using is the following:
      =AND($B2>=TODAY()+60, $B2

    • @OfficeFreak
      @OfficeFreak 4 роки тому

      @@ultraniusmaximus1536 Please check this Video. I think this Video may be helpful to you. Video is in Hindi language but it has English Subtitles

    • @ultraniusmaximus1536
      @ultraniusmaximus1536 4 роки тому

      @@OfficeFreak Could you post the link, please? I will check it out. Thank you.

    • @OfficeFreak
      @OfficeFreak 4 роки тому

      @@ultraniusmaximus1536 ua-cam.com/video/XNWD3TVER_w/v-deo.html

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

    Exactly what i needed thank you!

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

    Super helpful. Thank you

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

    Thankyou, this saved me hours!!

  • @michaelyong772
    @michaelyong772 2 роки тому

    Excellent. Very helpful. Thanks

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

    Thank you! So simple~

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

    Very well explained. Great Job!

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

    Very good, thank you.

  • @carlosvazquez8711
    @carlosvazquez8711 2 роки тому

    This is great stuff, thank you!

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

    How to highlight a cell after 5 days which contains a date. Cell should highlight after 5 days from the date in the cell.

  • @maraeuteneuer7789
    @maraeuteneuer7789 4 роки тому

    Great work!

  • @Olivia-ij6pi
    @Olivia-ij6pi 2 роки тому

    How come it highlights the entire column for me?

    • @OfficeFreak
      @OfficeFreak 2 роки тому

      ua-cam.com/video/VmrmnXMCx48/v-deo.html
      Please check this video. It might be helpful for you

  • @andreweuteneuer3861
    @andreweuteneuer3861 4 роки тому +1

    Good job!

    • @whyworksmarternotharder
      @whyworksmarternotharder  4 роки тому

      Thank you!!

    • @whyworksmarternotharder
      @whyworksmarternotharder  4 роки тому

      Appreciate your comment

    • @oanhluong7051
      @oanhluong7051 4 роки тому

      Hi! I need help with creating student employee estimation budget spreadsheet. I am not so sure how to create it because formula involved. Andrew can you help me? Thanks

  • @scottheddens7277
    @scottheddens7277 3 роки тому

    Great Vid.

  • @deborahmitchell966
    @deborahmitchell966 4 роки тому

    Great tutorial

  • @mizcanbro
    @mizcanbro 4 роки тому

    Nice job!

  • @aamirsohail4784
    @aamirsohail4784 2 роки тому

    Great vid😊

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

    great video

  • @AntonyVincent-v4u
    @AntonyVincent-v4u Місяць тому

    Super video

  • @mohanpal13555
    @mohanpal13555 4 роки тому

    Great work

  • @omni1691
    @omni1691 2 роки тому

    i did learn some thing - LIKE!

  • @alisonkelly3838
    @alisonkelly3838 2 роки тому

    amazing thanks

  • @valmarelysmorales4243
    @valmarelysmorales4243 2 роки тому

    I dont know what is wrong with my excel but I cant get it done. I followed every single step 3 times and it only accept 1 color. 😭

    • @OfficeFreak
      @OfficeFreak 2 роки тому

      ua-cam.com/video/VmrmnXMCx48/v-deo.html
      Please check this video. You might get some useful tips

  • @dlkhills
    @dlkhills 2 роки тому

    Nice

  • @dheerajjoshi3869
    @dheerajjoshi3869 2 роки тому

    nice video

  • @myeoss
    @myeoss 13 днів тому

    Good

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

    Great

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

    Thank u

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

    perfect

  • @yogibearstie
    @yogibearstie 4 роки тому

    Thanks

  • @TonyNRoca
    @TonyNRoca 3 роки тому

    Definitely smarter

  • @ryanculverwell
    @ryanculverwell 4 роки тому

    thanks

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

    🙂

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

    Tip: Don't insert audio that is much louder than the whole video randomly in your video. It hurts people's ears.

  • @stosgarage456
    @stosgarage456 2 роки тому

    Thanks