Essential Skill with Excel: Expiration Alerts with Conditional Formatting 

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

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

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

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

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

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?

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

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

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

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.

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

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

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

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

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

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?

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

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

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

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 ?

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?

Amazing video bro. Thanks. Very clear

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.

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.

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

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?

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

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

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.

Very good Explanations.. Thanks

Thank you so much. Great Video!

You my friend are a life saver. Thanks!!

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

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

Thank you for makinf it look so clear and easy!

Well Done Sir.

Great job.Thank you

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

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

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.?

Learning step by step, love it , thank you

is todays date update automatically day by day?

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

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

Thanks

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

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

thanks a lot

Thanks…It was helpful

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

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!

Thank you! This is so helpful!

Superb sir

Hi. Will this work on Google Sheets?

Useful video

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.

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

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

Thank you very much

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

Thank you ! Can we do that in power bi ?

Can it give me notification reminder

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

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.

THANK YOU

Thank you very much, helped me a lot.

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

Cool video. Thanks.

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

Thanks helped me a lot

Thank you!

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

this was very useful

A great presentation

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

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

super duper thank you so much :)

Thank you

it was useful thank you

you are the best

Expand please next time struggling to see it

THANK S BROTHER

wonderful

Its good explanation but the material is not readable.

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 ?

I couldn't see

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

This video not clear

I understood without understanding teeheehee

I cant see what he’s writing 😅

Your video is not to watching

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

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?

Thank you!

thanks