playlistduration

Conditional Formatting For Expiration Date Close, Due Date, Past Due Dates, and Other Date Tricks

by excelisfun · 20 videos

Total watch time

2h 44m

at 1× speed · exactly 2 hours, 44 minutes, 26 seconds at 1×

1×2h 44m 26s
1.25×2h 11m 33s
1.5×1h 49m 37s
1.75×1h 33m 58s
2×1h 22m 13s
Average video8m 13s
Longest16m 12s
Shortest2m 50s
Compare Open on YouTube JSON

Plan to finish

About 3 days at an hour a day

Pick a daily pace and the days you'll watch. Ticked videos are skipped.

Days

At one hour a day, every day, this playlist takes about 3 days. Turn on JavaScript to plan around your week.

Videos (20)

2h 44m in total · tick what you've watched

Tick videos you've watched — progress is saved in this browser.

Videos to
Watched
1 Excel Magic Trick 750: 7 Days Past Due Conditional Formatting & Logical Formula 5:00 2010-12-07
2 Excel Magic Trick 1173: Conditional Format Dates When they are 90 Days of Set Expiration Date 6:58 2015-02-07
3 Excel Magic Trick 631: Conditional Formatting Invoices 90 Days Past Due 4:46 2010-06-22
4 Excel Magic Trick 998: Conditionally Format Products As They Expire 6 Months From Creation Date 4:23 2013-05-31
5 Excel Magic Trick 1119: Conditional Format Date when 44 Days Have Passed 5:21 2014-05-30
6 Excel Magic Trick 1401: Conditionally Format Row For BOLD Date 7:27 2017-04-03
7 Excel Magic Trick 1124: Conditional Format Sundays & Weekends: NETWORKDAYS.INTL & NOT functions 6:05 2014-06-26
8 Excel Magic Trick 907: How To Make Excel Calendar (4 Examples) 16:12 2012-04-13
9 Excel Magic Trick 902: Conditionally Format To Do List If Date in Row is TODAY and Item Is Done 4:08 2012-04-07
10 Excel Magic Trick 806: Schedule with Holidays Conditional Formatting & Custom Number Formatting 10:26 2011-09-27
11 Excel Magic Trick 720: Show Records Between 2 Dates: Filter, Logical Formula, Conditional Formatting 7:22 2010-09-09
12 Excel Magic Trick 633: Conditional Format Dates for Year From A List Of Dates With Different Years 2:50 2010-06-22
13 Excel Magic Trick 534: Conditional Formatting for Weekends and Holidays 8:05 2010-03-02
14 Excel Magic Trick 327: Gantt Chart with Weekends and Holidays 8:16 2009-05-28
15 Excel Magic Trick 1448: Conditional Formatting Formulas: Cell References To “Jump” To Next Template 15:43 2017-07-04
16 Excel Magic Trick 1465: Conditional Formatting Holiday Dates with Red Fill & Word "Holiday" 9:27 2017-09-20
17 Excel Magic Trick 1478: Conditional Format Row When Event Code is a Duplicate AND Task = "Special" 8:11 2018-02-19
18 Excel Magic Trick 1509: Conditional Format Array Formula to Highlight Row With 2 Lookup Values 9:49 2018-07-20
19 Excel Magic Trick 1510: Conditional Format Row With Duplicates Based on Product & Color 9:21 2018-08-05
20 Excel Magic Trick 1512: Count Workers Employed 1 to 6 Years Based on Hire Date? 9 Examples 14:36 2018-08-10

Embed a badge

Show the watch time in a README or course description — it links back here and updates itself

Watch time: 2h 44m · 20 videos

Markdown
[![Watch time: 2h 44m · 20 videos](https://playlistduration.com/badge/playlist/PLrRPvpgDmw0ng9Oq7Zhhjp7oHv0tXIMdL.svg)](https://playlistduration.com/playlist/PLrRPvpgDmw0ng9Oq7Zhhjp7oHv0tXIMdL)
HTML
<a href="https://playlistduration.com/playlist/PLrRPvpgDmw0ng9Oq7Zhhjp7oHv0tXIMdL"><img src="https://playlistduration.com/badge/playlist/PLrRPvpgDmw0ng9Oq7Zhhjp7oHv0tXIMdL.svg" alt="Watch time: 2h 44m · 20 videos" width="203" height="20"></a>

Add ?speed=1.5 to the image URL for the time at that speed, ?label=Course to change the left text, or ?style=flat-square for square corners.

Want the numbers themselves? GET https://playlistduration.com/api/v1/playlist/PLrRPvpgDmw0ng9Oq7Zhhjp7oHv0tXIMdL returns them as JSON — free, no key. API docs →

Data from the YouTube Data API as of 2026-09-22 (cached). Private or deleted videos are excluded from totals.