Excel Essentials -- Level UP! -- Conditional Formatting for Due Dates and Expiration Dates

Do you have an Expiration Date or Due Date field where you want to quickly spot past due, expired -- or soon to expire items? If so -- this is the tip for you!

[@lalithadevidantuluru2797]

Hi , Rob . Thank you so much for the video. It helped me a lot. The way you explained is really good .

[@giovannyvivasrodriguez1235]

This video could be 5 years old, but my man has given me faster the answer than ChatGPT and Bard together (about 1 hour trying these AI ideas, that obviously didn't work) great work Rob, cheers

[@kamelkadri2843]

exactly the same, I knew the moment the video started with the audio being messed that this holds the answer, you never find what your looking for in a flashy video

[@Uchi_Soto]

This is so easy to follow, every other one taught this in the most difficult way possible.

[@soulcanyon]

Thank you Yissy! I'm glad it helped.

[@bmacallair]

I'm watching over 6 years later and this is the most helpful video every published online. I'm in college and my OCD thanks you.

[@soulcanyon]

Thank you. That is a high compliment indeed.

[@vanessaorozco4794]

OMG TY! Finding this video was a blessing! Super easy to follow! It helps that now I will be able to do my job easily! TY so so much!

[@yohannaagbanaji8012]

After 6 yrs of making this video I still find it helpful. Thank you so much.

[@soulcanyon]

Great to hear it!

[@RedCatPrints-g5l]

Spent an hour searching you answered the question in 2 mins 30 thank you for your video it's appreciated.

[@robertososaes]

Thank you Rob for the demonstration. Excellent explanation of the conditional. Thanks

[@soulcanyon]

Thank you Roberto. I'm glad you liked it.

[@loislaing4680]

I have been looking for this tutorial for months. I've seen other KZbin tutorials but could never get it to work properly (Operator Error!!) You have explained it so well that I now realise where I have gone wrong and my training matrix spreadsheet now works!! Thank you so much!!

[@richardpacheco8951]

Thank you Rob, I was searching for this to assist my daughter with a work spread sheet and you explained it so clearly. Indeed it is a big help and time saver for my daughter who is assisting people and does not want them to fall behind. This will simplify her work. God bless you and your family!

[@Fr4nkVG]

This video is worth a million dollar, best video ever, straight to the point. thanks a lot

[@soulcanyon]

Thank you! I'm happy it helped!

[@saithvatar1]

This video made it 10 times easier than anything else I could find online. Thank you so much!

[@soulcanyon]

Thank you David. I'm glad it's helpful!

[@shamindriperera576]

Thank you so much for teaching this easy step. God bless you.

[@cute130000]

This is much easier than other videos I watched. Thanks!

[@SandraPool-o3q]

This was the most informative video I have watched!!! THANK YOU

[@ericragan]

Rob! I cannot thank you enough, I was in a jam, knew there was a way to do this, I stumbled on your video after looking at a few other confusing videos. Yours was the best! To the point! And showed me another elegant way to do this vice the traditional way. Great job! Keep up the great work!

[@hellosimonhq]

Super useful video. Have set up a list of domains so it's nice and easy to see when they're expiring.

[@normasevilla2394]

"Boom, Drop the Mic"!!! Thank you Rob! I am a CTE teacher and my students work in a Lab style setting. I have five (5) courses going on at the same time and since I am all over the place in the classroom; this video for my Excel students has been a 'Blessing' in this chapter of their book! Thank you for the easy walk through. One thing I have learned through my walk is that: "If you don't use it, you lose it"!!! I will try to follow your videos and maybe your Essential courses!!👍 Again, Thank you to the moon and back!😃

[@soulcanyon]

Hey Norma -- Thanks for taking the time to post and I'm happy the video helped. Keep up the good work!

[@r.slicker2861]

Thank you so much! Doing a deadline list for my job and the web pages on how to do this are such jargon or only cover 1 formatting rule. This showed me perfectly how to set this up

[@soulcanyon]

Awesome. Thanks for taking the time to comment.

[@juliakingmusic]

Thank You so much for this video! I knew there was a way to do this and this was the only video I found to really lay out how to apply it simply to individual or groups of cells. This will help me so much with organizing my maintenance schedules!!

[@soulcanyon]

Awesome! Thanks for taking the time to comment.

[@positiveintentions-111]

Thank you. This would work perfectly to help me organize my cases at work which most of my clients have due dates to recertify. You explained it so clearly. I am going to test this when I go to work today. I did liked this video and I subscribed.

[@tbrown1352002]

We were literally in the same situation with our 15 y/o just a few days ago. I feared transmission issues but the airbox was full of acorns and other leftover fun mouse snacks and the air intake hose was ripped too. I did what you said and it accelerates perfectly now! Thanks so much for the video!!!

[@Jaadoo.]

thanks rob I am from Malaysia. I am searching this method at 4 a.m to manage my task. this helps me a lot, especially In the food industry.

[@soulcanyon]

Awesome. Glad it helped Khalid!

[@chavimann4263]

Thank you, Rob! This is simple and helpful.

[@pamelastewart118]

This tutorial is perfect! It saved me SO much time!! It's easy to understand and apply!!! THANK YOU!!!! I'm subscribing!!!!!

[@victorymansions]

This is far more simplistic than other tutorials, thank you

[@rastabroskah4657]

YOURE THE MANNNN. i was tryna import excel dates into outlook calender but this method is way EASIER and BETTER

[@redlipmovement]

Thank you Rob! This video is informative and easy to understand 👍🏻👍🏻👍🏻

[@soulcanyon]

Thanks and thank you for taking the time to comment

[@jamesjennings8574]

From the days of "boom shaka laka" to current day - the rest of this video is still very relevant. Thank you. BTW -- I hope you're not still saying "boom shaka laka"

[@roseleperlier1991]

I've tried many tutorials before I found yours! you saved my day Thanks a lot :)

[@SirSnoozebutton]

Perfect tutorial. Exactly what I was looking for

[@MarajAlZadjali]

Watched a lot of videos and wasn’t able to get what I want. But FINALLY! an easy step by step video and exactly to the point! Thanks a lot man! :)

[@diyasomnali3771]

How?? How is a guy from 6 years ago who says "Boom shaka laka" more helpful than google, GPT-4, my computer science honors teaacher, and the rest of youtube combined??

[@reesedombrowski4569]

You break it down so well! Made me look like a pro at work!

[@Shazzzzx]

Thanks Rob for short and informative video.

[@georgeshaw6207]

Superb video. Extremely well presented. George U.K.

[@peaceful4803]

How do I like this video a 10000 times? Thank you Mr.

[@Maithriist]

Rob, BOOM SHAKALAKA! Thank you for this! You made it SIMPLE and engaging. Will be taking the course suggested. Way to go! :)

[@soulcanyon]

I'm glad it helped. Thank you for taking the time to give feedback!

[@lisagarcia1807]

soon as I heard "boom-shakalaka" I knew this was gonna be good 😅! Thanks for this easy to follow guide.

[@tavinetavine9292]

Thank you!! Short and to the point ,just what I was looking for!!

[@isabellaagbotse5188]

Thank you Rob, this is extremely useful!

[@jayking1073]

Thank you so much for a clear and concise tutorial. This is fantastic

[@soulcanyon]

Thanks for taking the time for the feedback!

[@stevenzewe925]

Very solid information; thank you, Rob!

[@mariesmith8197]

This is really helpful, I have a large workbook with expiry dates for health and safety certificates. Until I found this video I have been trawling manually for expiry dates

[@cecillynponpon8287]

So easy to follow, I am subscribing.

[@nunya3163]

Such a clear, concise and downright helpful instructional video.

[@michellepeterson4655]

thank you so much for this! this help me so much. Everyone else utube was hard for me to get it.

[@jetracs]

This one rocks...thank you so much...subscribing from now on :)

[@soulcanyon]

Awesome. Thanks for the feedback!

[@sashaayunan5563]

Thank you sir, indeed it is a big help previously I was struggling with this due dates now it simplified my work. Salut! God bless you and your family.

[@miamia2726]

Thank you for making this so easy to understand

[@KimmiVision]

Thank you sooooo much! You just made my job so much easier

[@paul_isaac]

Thank you so much man. Used this for a tracker at work.

[@greggm1307]

Rob, I just discovered you. Thanks so much! You're a master at explaining these clever tips.

[@soulcanyon]

Thank you sir!

[@kathleenbias3249]

This is almost dead-on to what I'm trying to do. My only differences are these: Red=all dates before today; yellow=all dates this week; green=today; clear (or original formatting)=every date past the end of this week. The only question I have is what are the formulas for these conditions? Thanks bunches! You are really easy to understand, and I appreciate you!

[@Doratheexplorer-l7v]

this is the real video i need. Thanks!

[@darianford2522]

Thank you for sharing...I was racking my brain on how to do this

[@rhutikkadam9683]

It's always an old video from the internet that really helps you 😂

[@RCB504]

I love you!!!!!! Thank you. Made me the shiznit at my job.

[@soulcanyon]

Awesome! I love hearing that.

[@tyetucker1192]

Thank you so much for this tutorial. I’m using icon sets now

[@ajlim4535]

Thank you so much! This really helps! I've been looking for this for a week and finally found it! Thanks Rob :)

[@patticmcconnell]

Thank you so much for posting this video. It was simple to follow. I really love it when the teacher resonates with the audience (pupils). Subscribing to your channel & looking forward to watching more of your content. Great job.

[@soulcanyon]

Thank you Patti! Happy 4th of July!

[@thomasford4716]

This video was awesome! From here anyway i can populate a total column of items not expired?

[@beenice6332]

Best tutorial i found😊😊😊thank you

[@joaquimrabinovitch]

Thanks for the video, super helpful! Can you filter by icon set?

[@gauravmishra3474]

Very nicely explained. Kudos

[@therealistthereis3852]

This is very useful thanks Rob from another Rob.

[@vivealiasviruman]

Hi Robert It was an excellent narration in an understandable AV explanation. Thank you so much. I personally had great feeling you as a mentor.

[@soulcanyon]

Thank you Vivek!

[@jeanounou]

Very helpful man! I wasn't into dates, but more like "bigger than, between, and less than", but your tutorial helped me just the same. Cheers!

[@mathewkarmel-mdh-9749]

Awesome. You explained it very well and thanks a lot.

[@NoliPugay]

ohhhh I just follow you, I will learn a lot from your channel. Thank Rob for this you have simplified this so much

[@Sandeep_singh_sanju]

So so so helpful.. thank you so much

[@versieadams6680]

Thank you Rob, very easy to understand

[@osubri]

So clear and easy to understand. Thanks! 👍🏽

[@hassanmansoor5629]

Exactly what I was looking for, ty my man

[@tanyalee1770]

This is amazing thankyou for explaining this for us technologically challenged individuals.

[@soorajullas7919]

helped my boss to sort out his problem. Thanks :)

[@rivera82falcon]

Perfect! Exactly what I needed to know and how to do it.

[@ibtheartist]

This is exactly the video I was looking for thank tou

[@cristirx8572]

Great tutorial! Keep it up!

[@ahmadodeh7533]

Excellent..simple and clear .. good job

[@manishparihar4128]

Thank you for wonderful explanation

[@patiltransport-patilventur7330]

Simple and straightforward. Thanks a lot !!!

[@kirkoids]

Thank you. Very clear and concise!

[@andreacardenas01]

This was so helpful thank you so much!

[@JasonBolte]

Very helpful! Thanks for posting!

[@papaleotv2412]

nice tutorial this is very useful

[@rjdr6014]

Rob, Your tutorials are mind blowing - yet so easily explained. I hope you can help me solve my little problem. If I want to know that which month and year will come after 591 days from today - is there any formula in excel which will show it? e.g if today is 13.11.2022 - after 623 days it will be 28th July 2024 (Sunday). My mobile app can do that.... but can excel tell me that? In that format? even 28.07.2024 will do. If yes - Please tell me - how? Thanks in advance.

[@soulcanyon]

Format the cell with the formula in it to whatever date format you want. Formula is then =today()+591. If you want the exact date format shown in your question, you can set up a custom format of dd.mm.yyyy

[@soulcanyon]

And thank you for the compliment

[@rjdr6014]

@@soulcanyon Sir, You are a life saver. You replied so promptly and gave me exactly what was needed. So simple and so nicely explained. Thanks a million.

[@soulcanyon]

@@rjdr6014 You bet! Glad I could help.

[@Yheng.199x]

Thank youuu. This is so perfect.

[@soulcanyon]

Awesome! Glad it helped!

[@anoopgopalakrishnan7825]

Thank you for this video....thank you very much....It’s helpful for my work

[@soulcanyon]

Awesome. Thanks for taking the time to say so. Take care.

[@anoopgopalakrishnan7825]

💓

[@lazablan]

So helpful - thank you!!

[@rosekodnursing1308]

straight to the point and easy to understand.

[@paulguerra4886]

Helped me a lot! big thanks!

[@Berghiker]

Just what I was looking for. Thanks.

[@rockcop222]

You rock man! saved me a lot of time!

[@lovepeace1953]

You explained it in a very easy to understand way. Good on ya mate ;)

[@hauwaxo]

Love this 💯 thank you

[@soulcanyon]

Thank you for commenting!

[@AlvaEGQ]

Thank you, you helped me a lot today. :)

[@IngaFrid]

You are a saint! 🙏🏻✨

[@rinzin1204]

Awesome tutorial! Thank you 😊

[@despaterson8918]

Loved the icon tip