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!
Пікірлер: 437
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
4 ай бұрын
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
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!
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!
This tutorial is perfect! It saved me SO much time!! It's easy to understand and apply!!! THANK YOU!!!! I'm subscribing!!!!!
YOURE THE MANNNN. i was tryna import excel dates into outlook calender but this method is way EASIER and BETTER
"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
2 жыл бұрын
Hey Norma -- Thanks for taking the time to post and I'm happy the video helped. Keep up the good work!
I've tried many tutorials before I found yours! you saved my day Thanks a lot :)
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! :)
You break it down so well! Made me look like a pro at work!
I have been looking for this tutorial for months. I've seen other KZread 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!!
Thank you so much! This really helps! I've been looking for this for a week and finally found it! Thanks Rob :)
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!
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!!!
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.
This is far more simplistic than other tutorials, thank you
Rob, I just discovered you. Thanks so much! You're a master at explaining these clever tips.
@soulcanyon
2 жыл бұрын
Thank you sir!
Spent an hour searching you answered the question in 2 mins 30 thank you for your video it's appreciated.
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.
Thank you!! Short and to the point ,just what I was looking for!!
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
3 жыл бұрын
Awesome! Thanks for taking the time to comment.
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!
Perfect! Exactly what I needed to know and how to do it.
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.
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.
Such a clear, concise and downright helpful instructional video.
You rock man! saved me a lot of time!
This is amazing thankyou for explaining this for us technologically challenged individuals.
Simple and straightforward. Thanks a lot !!!
Thank you Rob for the demonstration. Excellent explanation of the conditional. Thanks
@soulcanyon
2 жыл бұрын
Thank you Roberto. I'm glad you liked it.
So clear and easy to understand. Thanks! 👍🏽
This is much easier than other videos I watched. Thanks!
This was the most informative video I have watched!!! THANK YOU
Very solid information; thank you, Rob!
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
3 жыл бұрын
Awesome. Thanks for taking the time to comment.
Perfect tutorial. Exactly what I was looking for
Thank you so much for teaching this easy step. God bless you.
Thank you Rob, this is extremely useful!
This video made it 10 times easier than anything else I could find online. Thank you so much!
@soulcanyon
3 жыл бұрын
Thank you David. I'm glad it's helpful!
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
5 жыл бұрын
Thank you Vivek!
Super useful video. Have set up a list of domains so it's nice and easy to see when they're expiring.
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!
Thank you sooooo much! You just made my job so much easier
Just what I was looking for. Thanks.
You explained it in a very easy to understand way. Good on ya mate ;)
Thank you Rob! This video is informative and easy to understand 👍🏻👍🏻👍🏻
@soulcanyon
3 жыл бұрын
Thanks and thank you for taking the time to comment
Rob, BOOM SHAKALAKA! Thank you for this! You made it SIMPLE and engaging. Will be taking the course suggested. Way to go! :)
@soulcanyon
4 жыл бұрын
I'm glad it helped. Thank you for taking the time to give feedback!
Thank you so much man. Used this for a tracker at work.
Great Tip, Awesome Work!
Thanks! It really helps me even in other way!
How do I like this video a 10000 times? Thank you Mr.
Exactly what I was looking for, ty my man
Excellent! This is great and thanks for sharing.
thank you so much for this! this help me so much. Everyone else utube was hard for me to get it.
Thanks Rob for short and informative video.
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
I love you!!!!!! Thank you. Made me the shiznit at my job.
@soulcanyon
3 жыл бұрын
Awesome! I love hearing that.
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"
You are a saint! 🙏🏻✨
Awesome tutorial! Thank you 😊
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!
Hi Rob, thanks for the super easy to follow tutorial. If I’m tracking training completions for a list of people and input the date they last completed the training how would I use conditional formatting based off this date? There are some trainings that need to be completed annually. A couple other trainings are due every 4 years.
Thank you. Very clear and concise!
This is very useful thanks Rob from another Rob.
Excellent..simple and clear .. good job
soon as I heard "boom-shakalaka" I knew this was gonna be good 😅! Thanks for this easy to follow guide.
Thank you so much for a clear and concise tutorial. This is fantastic
@soulcanyon
3 жыл бұрын
Thanks for taking the time for the feedback!
Thank you so much for this tutorial. I’m using icon sets now
Rob, do you have any suggestions for formatting so that the dates are evaluated relative to the length of an associated task? For example, if a project task effort is scheduled to last for 90 days, flagging it orange 30 days out would be very reasonable, whereas using the same 30 day measure for a task that is scheduled to last for 360 days might not be sufficient.
straight to the point and easy to understand.
Thank you for sharing...I was racking my brain on how to do this
Thank you so much, you have saved my day!
@soulcanyon
5 жыл бұрын
Awesome!
THANK YOU!!! LIFE SAVER!!!!
Superb video. Extremely well presented. George U.K.
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
2 жыл бұрын
Awesome. Glad it helped Khalid!
thanks. very simple and professional approach
Thank you Rob, very easy to understand
Helped me a lot! big thanks!
Awesome. You explained it very well and thanks a lot.
Thank you so much for a great video!
Thank your very much for your Great Tip
Very helpful! Thanks for posting!
This is exactly the video I was looking for thank tou
Thank u Rib! That really helped
Thank you, great information Boom Sha-ka-la-ka!
Thanks for the video, super helpful! Can you filter by icon set?
This was so helpful thank you so much!
Great tutorial-thanks!!
Hi, thanks for this awesome explanation. Quick question, I am using this format for a "bills payment checklist" so basically when the bill due date is 30+ dates away it is green, less than 30 days yellow, and past due red. I have also added a "checkbox" to click when the bill is paid. How can I make it reflect as green when I check the box, even though the date is past today? For example: right now, I have paid a bill for Oct 1st, but it is still showing red because it is Oct 6th, but it is not taking into account that the "Bill is Paid" box is checked. Hope I made this clear and that you are able to help, thank you so much for your time!
Great tutorial! Keep it up!
So helpful - thank you!!
I saved with this video, Thanks more
Thank you, you helped me a lot today. :)
Thank you so much for your explanation...Will try and write you.
Loved the icon tip
Very nicely explained. Kudos
Amazing, Thank you !
Best tutorial i found😊😊😊thank you
you had me at, "boom shakalaka" !!!!
This one rocks...thank you so much...subscribing from now on :)
@soulcanyon
3 жыл бұрын
Awesome. Thanks for the feedback!
you explained in a very professional way. Thanks, dear.
@alexvidu4517
5 жыл бұрын
Cheers for the video content! Apologies for the intrusion, I would appreciate your opinion. Have you tried - Weydaniel Organized Dominator (probably on Google)? It is a good one off product for getting 7000 plus project management and business templates minus the normal expense. Ive heard some extraordinary things about it and my work colleague at last got amazing success with it.