Use Conditional Format to Highlight Overdue Dates 

Thank you so much for such a concise and helpful explanation, this is exactly the information I require ❤

only summary for this function that took less than twenty minute. greatly appreciated.

This was exactly what I needed today, thank you for this quick tutorial 🤓

Finally, I found a video that helped me out. Thank you so much!!

Thank you SO MUCH for the note on the active cell. I couldn't figure out what was going wrong and that was it!

Great tutorial it was, easy and straight to the point

What if you want to add the conditional formatting to the whole column? So when I add more rows in the future the formatting will automatically be in the column. When I do this the blank rows turn red along with past due dates. I don’t want the blanks to turn color.

Hi! I hope you see this comment on an older video. This is SO CLOSE to what I'm looking for and I'm hoping you could help. What I'm looking for is, how can I highlight a cell if the checkbox it's linked to is "False" after a certain date? If the context helps I have a table that has each month as a row, and each cell in that row has a review for an employee that's due in that month. (For example in the January row it may have 1 cell that has Sally, another cell that has John, etc.) If Sally's review didn't get completed in January when it's due (the box is linked to a checkbox), then I want conditional formatting to highlight Sally's cell if the box isn't checked by February 1st. I hope this makes sense!!

Thank you. This is really helpful and easy to follow.

Well explained 👏

Great Video Chester !! Thank you soooo much ! It really helped allot !! To help those with multiple criteria & dates, this is what I got working for me and my company stock expiry list and also to "Highlight" the complete row. Row 1 to 2 was used as headers and filters, hence why I specified from I3 or AT3 Items was located in Column I - Named: "TEST" Dates was located in Column AT Item Expiry after 2 years To be removed out of storage after 2 years and 1 month. =AND($I3=("TEST"),(YEAR(TODAY())-YEAR($AT3)>=2),(MONTH(TODAY())-MONTH($AT3)>=1)) I sincerely hope this helps! Have a great one !

Thank you for the quick tutorial. To the point and fast. Will you be making the files available for us to use/practice with? Thank you for your teachings.

Amazing thank you! X

Brilliant. Thank you.

This was very helpful and easy to follow thank you!

Thank you!

Thanks for the Tutorial! How do you stop cells with no data inputted from turning the colour specified?

Thank you

Great tutorial - thanks!

Thank you so much. Very helpful!!! You received my thumbs up. Okay I also will subscribe you. Thanks again!!!

Is there a way to format the date to change its color to red when its 10 days after the certain date? lets say a cell with 12/2/2021 will turn red automatically when it will be 22/2/2021

I dont understand how to adjust this formula to let me know when the due date is within 30, 60, 90, and 180 days.... Ive tried several tutorials and they dont seem to be working with EXCEL 2016...

Great Video. Can you show a format for: If "Z" reads Unpaid, then highlight the row based on the overdue date in row Y. But, if row Z reads "Paid" don't highlight row Y based on the overdue date? Is there such a thing?

Okay...but how do I highlight the whole record including today's date?

Nice. Thx

If I select a range, and there are cells that are blank, it will highlight them. How do I change that, I don't want blank cells to be highlighted.

go on chester, back of the net