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
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
I have been looking for this tutorial for months. I've seen other RUclips 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!!
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??
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!
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 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!!
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!
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.
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
"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!😃
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"
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!
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
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?
You'll want to make the conditional formatting formatting formula condition key two years (just use a formula against the cell reference that contains the date and add 730 to it (2X365) -- close enough, right? So, the condition for that shading would be >= cell reference (e.g. B4) + 730, because a date is just a number sequenced by day with the numbering system starting on January 1, 1900. Try that and let me know.
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.
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.
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 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.
The conditions run at different windows of time with today being the anchor. So -- 6 months ago would be today() -183 or so. So, if the date in the cell is less than (
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
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
This is so easy to follow, every other one taught this in the most difficult way possible.
Thank you Yissy! I'm glad it helped.
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. That is a high compliment indeed.
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!
Spent an hour searching you answered the question in 2 mins 30 thank you for your video it's appreciated.
I have been looking for this tutorial for months. I've seen other RUclips 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!!
After 6 yrs of making this video I still find it helpful. Thank you so much.
Great to hear it!
Thank you Rob for the demonstration. Excellent explanation of the conditional. Thanks
Thank you Roberto. I'm glad you liked it.
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??
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!
This is much easier than other videos I watched. Thanks!
Thank you, Rob! This is simple and helpful.
Thank you so much for teaching this easy step. God bless you.
This video is worth a million dollar, best video ever, straight to the point. thanks a lot
Thank you! I'm happy it helped!
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 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!!
Awesome! Thanks for taking the time to comment.
This was the most informative video I have watched!!! THANK YOU
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 video made it 10 times easier than anything else I could find online. Thank you so much!
Thank you David. I'm glad it's helpful!
Super useful video. Have set up a list of domains so it's nice and easy to see when they're expiring.
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.
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
Awesome. Thanks for taking the time to comment.
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.
Awesome. Glad it helped Khalid!
"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!😃
Hey Norma -- Thanks for taking the time to post and I'm happy the video helped. Keep up the good work!
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"
This is far more simplistic than other tutorials, thank you
Superb video. Extremely well presented. George U.K.
Perfect tutorial. Exactly what I was looking for
How do I like this video a 10000 times? Thank you Mr.
It's always an old video from the internet that really helps you 😂
Thanks Rob for short and informative video.
Very solid information; thank you, Rob!
Thank you Rob, this is extremely useful!
Thank you Rob! This video is informative and easy to understand 👍🏻👍🏻👍🏻
Thanks and thank you for taking the time to comment
YOURE THE MANNNN. i was tryna import excel dates into outlook calender but this method is way EASIER and BETTER
this is the real video i need. Thanks!
Thank you so much for a clear and concise tutorial. This is fantastic
Thanks for taking the time for the feedback!
Thank you!! Short and to the point ,just what I was looking for!!
So easy to follow, I am subscribing.
soon as I heard "boom-shakalaka" I knew this was gonna be good 😅! Thanks for this easy to follow guide.
Thank you so much man. Used this for a tracker at work.
Such a clear, concise and downright helpful instructional video.
Rob, BOOM SHAKALAKA! Thank you for this! You made it SIMPLE and engaging. Will be taking the course suggested. Way to go! :)
I'm glad it helped. Thank you for taking the time to give feedback!
You break it down so well! Made me look like a pro at work!
So helpful - thank you!!
Love this 💯 thank you
Thank you for commenting!
This one rocks...thank you so much...subscribing from now on :)
Awesome. Thanks for the feedback!
This tutorial is perfect! It saved me SO much time!! It's easy to understand and apply!!! THANK YOU!!!! I'm subscribing!!!!!
So so so helpful.. thank you so much
I love you!!!!!! Thank you. Made me the shiznit at my job.
Awesome! I love hearing that.
Thank you sooooo much! You just made my job so much easier
Thank you so much for this tutorial. I’m using icon sets now
Thank you for sharing...I was racking my brain on how to do this
Very nicely explained. Kudos
thank you so much for this! this help me so much. Everyone else utube was hard for me to get it.
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!
This is very useful thanks Rob from another Rob.
This video was awesome! From here anyway i can populate a total column of items not expired?
Thank you for making this so easy to understand
Best tutorial i found😊😊😊thank you
nice tutorial this is very useful
Many thanks. I nedded this
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
Thank you for this video....thank you very much....It’s helpful for my work
Awesome. Thanks for taking the time to say so. Take care.
💓
Exactly what I was looking for, ty my man
Thanks for the video, super helpful! Can you filter by icon set?
Thank you for wonderful explanation
I've tried many tutorials before I found yours! you saved my day Thanks a lot :)
This is exactly the video I was looking for thank tou
Awesome. You explained it very well and thanks a lot.
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?
the formula, or condition, for the conditional format would be
So clear and easy to understand. Thanks! 👍🏽
helped my boss to sort out his problem. Thanks :)
I'm pretty sure I've come back to this at least once a week hahaha... 🤣
I can confirm after 3 months of posting the original comment ... that I do come here once a fortnight 😁🙄
Loved the icon tip
very helpful thanks
You're welcome!
So how do you format the cells to automatically shade 2 years after the date that is entered?
You'll want to make the conditional formatting formatting formula condition key two years (just use a formula against the cell reference that contains the date and add 730 to it (2X365) -- close enough, right? So, the condition for that shading would be >= cell reference (e.g. B4) + 730, because a date is just a number sequenced by day with the numbering system starting on January 1, 1900. Try that and let me know.
straight to the point and easy to understand.
Thank you. Very clear and concise!
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.
Conditional formatting is very useful for invoices' due dates.
Great tutorial! Keep it up!
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! :)
Thank you Rob, very easy to understand
This was so helpful thank you so much!
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.
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
And thank you for the compliment
@@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.
@@rjdr6014 You bet! Glad I could help.
Thank you
Very helpful! Thanks for posting!
You are a saint! 🙏🏻✨
Helped me a lot! big thanks!
Excellent..simple and clear .. good job
Rob, I just discovered you. Thanks so much! You're a master at explaining these clever tips.
Thank you sir!
Thank youuu. This is so perfect.
Awesome! Glad it helped!
Thank you, you helped me a lot today. :)
thanks dear brother for your help .....
What if i dont want to day it for today but like 6 months ago what would i use to replace today
The conditions run at different windows of time with today being the anchor. So -- 6 months ago would be today() -183 or so. So, if the date in the cell is less than (
Legend look like a boss now
Thank u Rib! That really helped
Beginning is great.
Perfect! Exactly what I needed to know and how to do it.