Highlight Overdue and Expiring Business Days | Conditional formatting in Excel | Excel Tutorial

Thank u

Thank you! Solved what I wanted to do for dates occurring within one week of Today()! ;)

Can you nest these functions?

Thank you - you have presented in a way that I can understand.

Thank you so much! Great Job!

Thankyou, this saved me hours!!

Thank you! That Today() function is really powerful

Exactly what i needed thank you!

How to highlight a cell after 5 days which contains a date. Cell should highlight after 5 days from the date in the cell.

Hey, I have 2 colums. Colum C is the date of the test i did. Colum D is the due date in 3 months time. How do i create rules so within from day test was done to 1 month away from due date the colum is green. 1 month to 1 day before due date it is yellow then the date the new test is due and beyond it is red? Colum D is set up as =EDATE(C2,3) So I only ever need to input the new date i've done a test.

great video

This worked for what I needed!

Thank you! Can I add I new column to tick off any completed dates, removing the red highlight?

perfect

Tip: Don't insert audio that is much louder than the whole video randomly in your video. It hurts people's ears.

🙂

Super helpful. Thank you

Great

if the due dates is not a fixed date for all the rows, then ? if every case number had a different due date in column C then what would be the formula ?

Great Video, Thanks

This was very helpful. Thaks for taking the time to share!

Quick and good information.

Thank you! So simple~

Very well explained. Great Job!

Can you tell me how I can get reminders from excel to my outlook ?

Very good, thank you.

Question. So if I put today's date in 1-6-2023 will the sheet automatically turn that text red on 1-11-2023 because it's been five days?

Hi, may i ask how to set the weekends to count saturday on the weekends ? because my company work on sat on the first and third week

very good introduction for me. I have been mucking around with the today function without much success, Thanks

Nice

Great vid😊

i did learn some thing - LIKE!

I dont know what is wrong with my excel but I cant get it done. I followed every single step 3 times and it only accept 1 color. 😭

I have looked all over for exactly this video, Thank you!!!!! A little quick but precise.

Excellent. Very helpful. Thanks

nice video

Thanks

amazing thanks

How come it highlights the entire column for me?

is it applicable to google sheets too?

This is great stuff, thank you!

Definitely smarter

Great Vid.

Ugh. It took me like 30 minutes to teach this to myself! haha, wish I had found you sooner!

Great tutorial

Thanks for this video! Ok, so more questions for you...
I'm familiar with the today() function by adding or subtracting days from today, but what I'd like to know is how to show expiring dates in the future (e.g. 3 months, 2 years and so on)? Also, how would I apply that to multiple, non-consecutive columns in a worksheet? I've tried using absolute, such as $B$4, but when I go to apply that to multiple columns like I described above, it keeps using that cell's specific date and not the date of the other cells I want it to effect.

And last question (promise!): is there a way to have some kind of notification such as a pop-up window when a certain date has expired, or is expiring very soon (aside from just colors)?

thanks

Thanks

Nice job!

Great work