filmov
tv
Highlight Dates that are Past the Due Date in Excel (or about to be due)
![preview_player](https://i.ytimg.com/vi/zqkINF31_nw/maxresdefault.jpg)
Показать описание
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 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
Комментарии