Rob Hambleton

Пікірлер

@tonyjacobs465 7 күн бұрын

his is great but the yellow is not working - also what is the best for me to take the data and use it in another sheet and for Expired, soon to expire etc

@LiYagas-p9q 13 күн бұрын

Thanks much. I also Wana do this for time duration, can you help show us how that can be done? Thanks again

@lalithadevidantuluru2797 15 күн бұрын

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

@Mr.Moe.95 21 күн бұрын

Can I make it automatic? When something expires it automatically turns red, how?

@Doratheexplorer-l7v Ай бұрын

this is the real video i need. Thanks!

@chavimann4263 Ай бұрын

Thank you, Rob! This is simple and helpful.

@RubenGonzalez-hq5hh Ай бұрын

How do I sign up? The site only gives the option to log in

@donetgarcia3371 2 ай бұрын

Hi, how about with the no weekends? How is the formula?

@PMdwn 2 ай бұрын

Please tell me how to do it with a 30 60 and 90 for each color Thank you!

@StarYayyRBLX 2 ай бұрын

How can you make it show that it will expire yearly? Do I have to change the start date yearly to show the expiration date?

@cecillynponpon8287 2 ай бұрын

So easy to follow, I am subscribing.

@aseerpc8736 3 ай бұрын

❤❤

@miamia2726 3 ай бұрын

Thank you for making this so easy to understand

@arifkadir7456 3 ай бұрын

❤ Thanks Sir.

@rckygrhm1 4 ай бұрын

Hello and boom shackalacka..

@MusicSkiesAndStars8 4 ай бұрын

I need to organize a bunch of committees at work (mainly term expirations) on an Excel sheet. It takes us a year to find/approve new members for committees. If I want to be alerted that a committee member’s term is going to be expiring in the coming year, is there a way to do that?

@cornellm2985 4 ай бұрын

Thanks man.

@rhutikkadam9683 4 ай бұрын

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

@princesource4822 4 ай бұрын

What if i dont want to day it for today but like 6 months ago what would i use to replace today

@soulcanyon 4 ай бұрын

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 (<) today()-182, that date would b earlier than 6 months ago and that would define the condition.

@yohannaagbanaji8012 4 ай бұрын

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

@soulcanyon 4 ай бұрын

Great to hear it!

@jvicinip 5 ай бұрын

Many thanks. I nedded this

@2007dodi 5 ай бұрын

it didn't work with me

@soulcanyon 5 ай бұрын

It works. Keep trying.

@soulcanyon 5 ай бұрын

There are so many moving parts with conditional formatting -- including overlapping conditions, ranges, formatting options etc. -- just keep reviewing the video -- pause it and keep trying. You'll get it.

@catherineosborne4374 5 ай бұрын

Stay strong in the Lord. She's home with the father. One day will all be home as well . God Bless you . May the peace of the Lord comfort you in these difficult times. God speed.

@coreymctaggart9834 5 ай бұрын

We love Ashley. ❤

@coreymctaggart9834 5 ай бұрын

Love you Ashley ❤

@narnow777 6 ай бұрын

Hi! Is there a way to automatically apply the conditional formatting to additional rows that are to be added?

@ozmaorigrl 6 ай бұрын

I'm pretty sure I've come back to this at least once a week hahaha... 🤣

@ozmaorigrl 2 ай бұрын

I can confirm after 3 months of posting the original comment ... that I do come here once a fortnight 😁🙄