Excel Conditional Formatting with Dates - 5 Examples

In this video, we show 5 examples of using Conditional Formatting with dates.

Working with dates is a very common use for Conditional Formatting. Highlighting the overdue dates, and milestone dates etc.

Did you know the formulas shown in this video?

These 5 examples will give you a nice idea of what can be done with formulas in Conditional Formatting rules.

Find more great free tutorials at;

*** Online Excel Courses ***

Connect with us!

[iamtomwood]

I never comment on videos, but this was exactly what I was looking for. Thank you for making my Excel work easier.

[mercnem]

an absolutely amazing video that clearly explained the process. Thank you so much for the time and effort

[ModeBespoke]

Perfect! Just what I looking for. Thank you so much!

[byDsign]

Saving for future reference! Thanks for sharing!

[BegurKailash]

Crystal clear way of explaining. I luv your videos.

[Today]

Life saving! Thank you so much for sharing.

[toddharrison]

Great stuff. I have a question. Suppose your list of names is expanding over time. Can you format the entire column (C in your example) and have the empty boxes remain empty until a value is placed in them without having to reformat as names and dates are added to your list?

[MrAnandselva]

Thank you so much for the Video. It is really very useful.

[yarived]

That's brilliant!! Thanks so much for explaining how to highlight a day of the week!

[mohideenthassim]

Great tutorial, many thanks Alan. Cheers Mohideen

[sasavienne]

You are so smart Alan. I am really glad that I found you on Youtube.

[SimpleAbundance]

I have a large table, and applied conditions to all cells, even cells that data hasn't been entered yet. Is there away to remove my eye sore Expiry highlight conditions for cells without data yet? This has been an awesome tutorial and extremely helpful. Thank you for posting this. I'm going to save it to a private list to review at later dates incase i forget!

[cornishcoastwalker]

Thank you, as usual very clear simple instruction well explained.

[growqueen]

Thank you I have just started a job as a project coordinator and I wanted a way to check up on outstanding tasks not completed. I watched a video before this one and the process didnt work. I watched your video and all I can say is this is exactly what I wanted. Thank you.

[doboslevente-szilveszter]

Hello, really helpful video, thank you. I have a question. I have a table with some subscription dates, and I wanted to see which subscriptions are going to expire – and it's ok with your 2nd example in this video. So let's say I save the document and close it, and I recheck it after a month. Will the formatted cells remain like that, or they will be updated automatically? If you know, what I mean... Thank you!

[nedaari]

Great sir! Answered my question in the first 2 minutes!

[WAdam]

Very professional video, I still cant get mine to work though. I want to highlight red the dates that have expired by 12weeks can you help?

[TextbookBoxingGB]

Is there any way to do this

I have a table with two columns both with dates in. I want to highlight the individual rows if the difference between the two dates is over 1 month. Any help appreciated

[MrNobbyc]

Hi Gaga, Please can you help i am trying to figure out how to show dates that older than 6 months from today as red and dates that within 6 months old as green for instance 12/12/21 would be Red where 4/4/23 would be green but i need them to update daily.
So hope you can help with this as it is driving me nuts

[marstoilov]

Great video, thank you! I am just curious how you can highlight every other Sunday.