Highlight Dates that are Past the Due Date in Excel (or about to be due)

preview_player
Показать описание
In this video, learn how to highlight cells with dates that are past the due date.

This can easily be done using the TODAY function in conditional formatting.

In this video, I cover the following two examples:
⏵ How to highlight dates that are past the due date
⏵ How to highlight dates where the due date is in the next 5 days

This video is a part of my 'Excel is two-minute' series, where I share simple and quick tips to help you speed up your work and be more efficient

This YouTube channel is managed by Sumit Bansal (who also runs the TrumpExcel website). This channel is meant for people who want to learn Excel.

It covers a lot of Excel basics and advanced Excel topics such as Excel Formulas, Functions, Pivot Table, Shortcuts, Excel VBA, Macros, Excel Dashboards, Excel Charts, Conditional Formatting, Power Query, etc. Please subscribe to this channel to be the first to know when new Excel tutorials come out.

⚙️ Gear I Recommend:

Note: Some of these links here are affiliate links!

#Excel #ExcelTips #ExcelTutorial
Рекомендации по теме
Комментарии
Автор

This was super quick and easy compared to other methods I found on the internet. Thank you so much!

Dwho
Автор

Just what i needed!!! Very helpful, Thank you.

greenstreet
Автор

I'VE BEEN SEARCHING FOR THIS FOR HOURS ( AT LEAST 4S) AND IM BREATHLESS WITH THIS:
=ArrayFormula( if(C2:C="";""; ifs(today()-C2:C>0;"Finish"; today()-C2:C=0; "Today"; today()-C2:C >= indirect("'Set "& if(ABS(today()-C2:C) < 2; "Day"; "Days")&" "&"before event"; today()-C2:C < INDIRECT("'Set Reminder'!A1"); "Waiting for a reminder")))

but THEN i found this video that making me feeling so dumb hahaha.
Thank you so MUCH GREAT JOB

anbeck
Автор

Thanks Brother, it was so easy but I couldn't catch it before this video. Stay blessed ❤

Mr.Gurinder
Автор

Wow! I watched this the same day it was uploaded :) Today() = 13/10/2019 By the way, great work Sumit !! Your videos are among the best in YouTube!

georgetosounidis
Автор

This was quick and useful. Thank you so much!!!!

anthonywright
Автор

Damn useful content within 2-3 minutes! Thanks a lot!

aniruddhashriwant
Автор

Hi Sumit.. great tips on conditional formatting for dates. Thanks for sharing. Thumbs up!

wayneedmondson
Автор

Very useful trick 👌
Yet simple solution 👍

devendrabain
Автор

Thank you for this. easy to follow along

MarkytheSparky
Автор

Great initiative sumit... I do appreciate your efforts.. As I am working on excel from last 5 years but these are great tricks..

munendrarathore
Автор

Hey, buddy! Thanks a lot for this video. Really useful! Although, as someone mentioned below, empty cells get formatted too. How can I avoid that? Thanks in advance and keep up the good work! You've got a new follower ;)

INGLEASY
Автор

Empty cells are formatted too. How do I keep empty cells clean until I enter the date?

jorgekern
Автор

Any suggestions on cells that do not contain a date? I dont want them to be highlighted red if they are empty. I only want cells in the range to be highlight if there is a date available.

Trabbas
Автор

Thanks for this video. Is it also possible to do this with vba?

peteronderwater
Автор

Very good instructions, but what if I want to highlight the entire row of the past dates? Thank you

lucianopascual
Автор

Hi, what if we have more versions and have separate dates than what will be the formula

khurshid
Автор

Which formula use when due date come and than send mail automatically from excel to concern person

kataramukesh
Автор

If I want to Highlight the whole line not only a case ?

mejab
Автор

I tried to follow it but nothing happened. It didn't highlight the past due date and only highlighted blank cells. Help.

geraldinehernandez