Essential Skill with Excel: Expiration Alerts with Conditional Formatting

[@bxcinderella]

11:37 Noooo, we're not bored at all! Thank you for NOT skipping any steps (however irrelevant) 😊

[@dbhakimi_.5123]

This video was very helpful for my internship project. Thank you very much!

[@mmmm-xm5fc]

After watching this video i believe "NOTHING IS IMPOSSIBLE" Thanks a lot it was really helpful for my project ...

[@fakdolan]

So easy to follow, you're a great teacher, ty!

[@theophilusdada1222]

Although the quality of the video is not really clear yet I learnt a lot from it. Thank you very much

[@jasongochez1140]

I know this is a couple of years old but this helped immensely. Thank you very much.

[@Info365d]

Great Sir, What a beautiful and detailed explanation, love it. Thanks

[@vinaynagaonkar8592]

Its a wonderful tool, Thank you very much, God Bless You

[@jasminehang2820]

This video was so easy to follow. I have finally found one that I can easily understand and not get confused.

[@mohamedyusufmohamed6288]

Man thanks for this, you are the best. Your video helped to fix the best document for our maintenance team to not forget all service days in our production.

[@lilakarisma2311]

This video was so helpful!! I used this to organise my assignments and it works like a charm. thank you!

[@jonatancohen]

Amazing video bro. Thanks. Very clear

[@freemanstandsbyhumanity]

Superb!!! You have made my life easy. Subscribed 👍

[@786NOUSHAD]

Thank you so much for you training your so kind and its very easy to understand

[@nurizzatirossdi6165]

Thank you so much. U make it more easier to understand! I have very limited knowledge with excel since i rarely use before. Done Subscribing your channel. Will refer to your channel to explore more about excel.

[@AbdulrahmanAlahdal-lc3wz]

Thank you so much the video was really helpful and explained it in a very clear and easy way.

[@venkateshwaran666]

Very good Explanations.. Thanks

[@LarPam]

Thank you for makinf it look so clear and easy!

[@van6281]

Your explanation is really good!!! Thank u so much

[@sagarabrian2882]

You my friend are a life saver. Thanks!!

[@hakiinmohamud9852]

Thank you so much. Great Video!

[@rajeshkumarsharma4752]

Very useful ! Use of pivot tables at the end has given a summary.

[@SenthilKumar-xu9fb]

This Video is very useful. I have try for using this formula for maintaining chemical expiry monitoring. is is fine and working good. Thanks

[@watajs1430]

Amazing and very easy to understand, Thank u so much...

[@officialveronicawrites]

dude thanks so much!! I am doing a work report and this is exactly what I needed! thank you so much, very clear instructions! Subscribed

[@fahdiqbal1609]

Learning step by step, love it , thank you

[@kalistaflowers5999]

AMAZING VIDEO! Thank you so much for helping. Clear and step by step instructions :)

[@Mahbub_L]

Thank you so much. Is there any possibility if this workbook is in CLOSED mode and it'll send email reminder to the user when a product delivery date about to expire?

[@Odawg421]

Great video. This is getting me closer to what I’m looking for. In this example that you’ve created, is there a ways to calculate the remaining days excluding weekends and/or holidays?

[@bvlbvl3331]

Great video but at/around 7:41 seconds, I do not know if it just my computer but it is hard to clearly see the formula written in the formula bar. It would be great if that could be copied/pasted - it is the part showing the nested if

[@soethida5401]

it is very useful for me. thank you so much.

[@ishtarshehera]

amazing!!!!!!!!!!! best tutorial ever!!!

[@imransiyal801]

Well Done Sir.

[@IXxfranCxXl]

Thank you! This is so helpful!

[@husamaineia795]

thanks a lot...Thant's helped me to much

[@rahulpawar8130]

Thanks a ton man...🤗 Its a great help 💐

[@mosestimothy673]

Thanks…It was helpful

[@chukwunonsoamaikwu9621]

Thank you very much, helped me a lot.

[@COCOCOCO-bp7vn]

Great job.Thank you

[@muhammadsyahirnorazman2037]

This is very helpful! You got my like and sucsribe.

[@monamidog]

So clear and the explanation is also on point, thanks a lot.

[@rajeevgosavi4514]

Good Formula. However would appreciate if you explain using zoom , as at some points can't figure out.

[@pandharinathjoshi6565]

Superb sir

[@st3kilho]

Thanks helped me a lot

[@bluephoenix9]

Cool video. Thanks.

[@AmarFemco]

Useful video

[@MyLifeWithAI]

Thanks for that video - it is useful. My question is is Today automatically updated - for example -if I open the file tomorrow - is it going to present tomorrow's date automatically without doing anything on that filed?

[@melleaidandeguzman2584]

can i connect this to a calendar? (with the list of my due assignments). btw thanks! great vid

[@munyaradzinherera3383]

A great presentation

[@brendamichieka3743]

this was very useful

[@melbertseraspe4301]

Thankss for this video learned a lot. However I have a question if how do you make an excel formula to know the expiration of the items you bought 2-3 months and then you want to monitor their expiration lets say 6 months expiration from the month you bought the items.?

[@bilelk2388]

Thank you ! Can we do that in power bi ?

[@fokhrulabedin]

Hello, I have a list of product, those have different different expire dates. I want my product status cell will be red color after a certain product has expired. Which formula should i use in conditional formatting?

[@sabinocasas9295]

this is a great video, a couple of questions, let's say, once you get the 3 day warning, how can i have excel notify me via outlook? also, how can I send a reminder to several or many people that they need to send out the invoices (in this case) for the ones that have the 3 day warning only? thanks very much in advance!

[@jeanyosita3537]

super duper thank you so much :)

[@observer8291]

Thank you very much

[@CGAZ66]

how would you do a start dates that may be different then each other and a end date that is different then each other?

[@CGAZ66]

question ........does the today date change with the actual date per day???

[@freemanstandsbyhumanity]

Hi there! How can we insert a row with data after each row as I need to do it manually and print it with Emplyee name, DOJ, Salary for each and every employee. It takes lot of time to copy n paste same row for each employee. Pls help.

[@ab-bc2gr]

How can I set an alert to notify me (via pop-up message) when I open an excel file on: The day before the 3rd Friday of March, June, Sept and Dec of any particular year ?

[@ragsyrazor]

Best video!!!!!!!!!!

[@noobstationgaming6733]

you are the best

[@NishanAman-h2m]

is todays date update automatically day by day?

[@zakarialaghrissi9342]

it was useful thank you

[@dragontamerdragonking9215]

Please help I’m trying to add a 4th option “Completed” but I’m receiving an error… I do not want all to show expired.

[@christoperharis2468]

Could i change the conditional formatting with icon set ? Could you demonstrate it please ?

[@KingLouie91]

Could you add a nested if to ignore blank cells? For example: =ALS(G7

[@trentorhu7587]

Hi. Will this work on Google Sheets?

[@mohammedafeef7301]

Great ...how to send email alerts before expiry let's say before 15 days to my email saying this is going to expire soon...THANK YOU

[@richardbelliveau8881]

Im trying to set it up so when i enter a date.....i have a warning at 330 days ( yellow) and another warning at 360 days( red). How do i set that up?

[@nickynicku9795]

Thank you!

[@narmididi6336]

Hello bro, this is very useful and it definitely very helpful for work. You're good! But next thing, after having all the dates, when i used MATCH function to search for a particular date to filter, I cannot do so as the date cells which were calculated with the formula is "packed" with formulas and i think excel MATCH function cannot recognise the value inside to return... are you able to assist pls? Thanks.

[@credencehomehealthservices]

THANK YOU

[@CryptoAirDrop.0]

Can it give me notification reminder

[@WenboCanadaImmigration]

thanks a lot

[@dedy4862]

Thank you

[@sayemhasan3138]

THANK S BROTHER

[@rogerkd89]

wonderful

[@rajasekaransundararaj6975]

Sir, I simply say Thanks though I could not follow you. It is difficult to see your display as you have not made the screen 'bigger' like all others YT videos. Need reproduce in zoomed screen please.

[@HMVGARAGE]

thanks

[@69woow]

I couldn't see

[@KareemAdel-c5k]

Hii, Thank you for this video, can you help me how i can receive and email in gmail once the value got About to expire ?

[@ekaetteasuquo5265]

Expand please next time struggling to see it

[@JacobBogovefa-bb4os]

i like it, really helpful however its not clear enough to see.

[@jozefchromy8044]

thumb up for the tutorial, but to join you, you would have to learn how to zoom your tutorial - think about you viewers man, after all not everyone has a 20/20 vision and then it becomes a struggle to watch. Some tutorials pay great attention to show, up close the viewer, what they want to convey to them that is kudo for them but this......... Greetings

[@inuchan5548]

Its good explanation but the material is not readable.

[@Hamdanfariid]

For 2:01 days remaining i get 01/01/1990 help guys

[@ub69hs]

I understood without understanding teeheehee

[@grajesh4562]

This video not clear

[@skinnyulam6801]

I cant see what he’s writing 😅

[@sunsophat]

Your video is not to watching

[@ASIFSADDIQUE]

Very poor video quality, hardly can see anything. Improve the video quality that we can see clearly. Otherwise good explanation

[@JohnPaul-sp5bf]

Thank you!

[@neelprasanna6648]

after charging the warning date the 'about to expire' it is not change to expire. How it happen? Formulas and every thing is ok

[@darshanawajira3826]

Thanks