playlistduration

Excel Conditional Formatting Tricks

by excelisfun · 142 videos

Total watch time

17h 59m

at 1× speed · exactly 17 hours, 58 minutes, 40 seconds at 1×

1×17h 58m 40s
1.25×14h 22m 56s
1.5×11h 59m 7s
1.75×10h 16m 23s
2×8h 59m 20s
Average video7m 36s
Longest1h 28m 15s
Shortest1m 39s
Compare Open on YouTube JSON

Plan to finish

About 18 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 18 days. Turn on JavaScript to plan around your week.

Videos (142)

17h 59m in total · tick what you've watched

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

Videos to
Watched
1 Highline Excel 2016 Class 16: Conditional Formatting to Visualize Data: Built-in & Logical Formulas 44:21 2016-05-23
2 Highline Excel 2013 Class Video 40: Conditional Formatting Basic To Advanced 50 Examples 1:28:15 2013-11-28
3 Ctrl + Shift + Enter: Excel Array Formulas 21: Conditional Formatting with Array Formulas 16:02 2014-02-19
4 Excel Magic Trick 1072: Conditionally Format Partial Row Based On Start Month, End Month & Product 10:35 2014-02-19
5 Excel Magic Trick 787: Conditional Formatting Basic To Advanced (30 Examples) 1:09:30 2011-05-27
6 Highline Excel Class 21: Conditional Formatting 12 Examples 18:23 2009-05-18
7 Excel Magic Trick 631: Conditional Formatting Invoices 90 Days Past Due 4:46 2010-06-22
8 Excel Magic Trick 1097: AND & OR Criteria Together for Counting, Adding, Conditional Formatting 8:38 2014-04-11
9 Excel Magic Trick 685: Conditional Format For Alternative Rows 4:53 2010-07-31
10 Excel Magic Trick 544: Conditional Formatting Row With Multiple Criteria In Other Columns 4:39 2010-03-12
11 Excel Magic Trick 514: Conditional Formatting Duplicate Values (3 Methods) 5:00 2010-02-21
12 Excel Magic Trick # 270: Conditional Format Based On Diff Cell 3:28 2009-03-02
13 YouTubersLoveExcel#42: Format Negative Numbers 2:30 2008-06-27
14 Excel Magic Trick #6: Conditional Formatting for a Row 3:10 2008-03-03
15 YTLE#78: Conditional Format for Entire Table 2:34 2008-08-04
16 Excel Magic Trick 424: Conditional Formatting For Dynamic Range 6:31 2009-10-26
17 Excel Magic Trick 564: Daily Gantt Chart 8:33 2010-04-05
18 Excel Magic Trick 565: Excel 2010 Daily Gantt Chart 11:14 2010-04-05
19 YouTubersLoveExcel#43: Data Validation & Conditional Format 4:12 2008-06-27
20 Excel Magic Trick # 268: Conditional Formatting Max In Row 2:54 2009-03-02
21 Excel Magic Trick 296: Conditional Format Intersection Row & Column 6:11 2009-03-23
22 Excel Magic Trick #98: Conditional Formatting for Calendar 3:21 2008-07-01
23 Excel Magic Trick 157 Conditional Format Part of Table 3:15 2008-12-02
24 Excel Magic Trick #170: Conditional Format To Hide Items 2:39 2008-12-30
25 Excel Magic Trick #153: Conditional Formatting for Incentive 6:50 2008-11-19
26 Excel Magic Trick #199: Histogram w Conditional Formatting 2:39 2009-01-09
27 Excel Magic Trick #110: Partial Text Conditional Formatting 7:18 2008-10-10
28 YTLE#101: Custom Number & Conditional Formatting - Excel 5:35 2008-08-30
29 Excel Magic Trick #120: ISNUMBER & SEARCH functions 3:54 2008-10-17
30 YTLE#81: Conditional Format CHART?? 7:27 2008-08-04
31 YouTubersLoveExcel 29 Conditional Formatting & LEFT function 5:15 2008-06-06
32 YouTubersLoveExcel#17: Hide Bank Rec Formula 10:37 2008-05-23
33 YouTubersLoveExcel#28: Complex & Amazing Excel Trick 9:45 2008-06-07
34 Excel Magic Trick #93: Gantt Cell Chart Conditional Formatti 3:54 2008-07-01
35 YTLE#80: Conditional Format MATCH & INSUMBER functions 8:18 2008-08-04
36 YTLE#106: Alternatives To Pivot Tables - Excel 9:23 2008-08-30
37 Excel MT142 p1: Custom Number Format & Conditional Formatting for Dates & Weekends 9:52 2008-10-28
38 Excel Magic Trick #136: Two 2 way lookup with VLOOKUP & MATCH 3:45 2008-10-28
39 Excel Magic Trick # 271: Conditional Format w DATEDIF function 5:28 2009-03-02
40 Mr Excel & excelisfun Trick #5: Horizontal Subtotals 10:18 2009-04-09
41 Excel Magic Trick 350: Conditional Format Values Listed 3 Times COUNTIF function Trick 4:17 2009-07-29
42 Excel 2010 Preview #5: Conditional Formatting Negative Data Bars 3:00 2009-07-29
43 Excel Magic Trick 354: 2 Criteria Counting for Blood Sugar Levels 8:57 2009-08-07
44 Excel Magic Trick 353: Date VLOOKUP for Seasons 5:01 2009-08-07
45 Excel Magic Trick 383:Conditional Formatting Between a Max and Min 4:07 2009-09-10
46 Excel Magic Trick 386: Less Than the Letter M Conditional Formatting 3:59 2009-09-10
47 Excel Magic Trick 388: Conditional Formatting and the Active Cell 3:29 2009-09-17
48 Excel Magic Trick 421: Conditional Formatting Row with MAX or MIN Value 4:24 2009-10-19
49 Excel Magic Trick 422: Conditional Formatting 1st Two Rows Regardless of Sort 3:32 2009-10-19
50 Excel Magic Trick 467: Conditional Formatting every Nth value (Conditional Format) 3:55 2010-01-01
51 Excel Magic Trick 474: Conditional Format At Every Change In Value 1:52 2010-01-05
52 Excel Magic Trick 490: Conditional Format for Budget Less Than $500. 5:27 2010-02-02
53 Excel Magic Trick 516: Conditional Formatting Duplicates In Each Row COUNTIF & Mixed Cell References 3:12 2010-02-23
54 Excel Magic Trick 554: Conditional Formatting for Weekends and Holidays Better than EMT 534 4:27 2010-03-23
55 Excel Magic Trick #394: IF Function and Conditional Formatting 5:04 2009-09-26
56 Excel Magic Trick 560: Conditional Formatting Select OK, Column Numbers Get Font White 2:32 2010-03-27
57 Excel Magic Trick 566: Conditional Format A Chart Student Grades 5:00 2010-04-05
58 Excel Magic Trick 575: Conditional Formatting & Counting with 3 Criteria & Find Formula Mistakes 7:36 2010-04-23
59 Excel Magic Trick 587: Conditional Formatting 3 Criteria including SEARCH for Text Contains Criteria 8:08 2010-05-03
60 Excel Magic Trick 621: Conditional Formatting Unique Items With One Criteria 8:38 2010-06-04
61 Excel Magic Trick 633: Conditional Format Dates for Year From A List Of Dates With Different Years 2:50 2010-06-22
62 Excel Magic Trick 626: Time Gantt Chart -- Conditional Formatting & Data Validation Custom Formulas 15:54 2010-06-13
63 Excel Magic Trick 626: Time Gantt Chart -- Conditional Formatting & Data Validation Custom Formulas 15:54 2010-06-13
64 Excel Magic Trick 640: VLOOKUP and Conditional Formatting to Highlight Row with Low Rank 4:36 2010-07-12
65 Excel Magic Trick 743: Conditional Formatting To Match Items In List On A Different Sheet 4:53 2010-12-08
66 Excel Magic Trick 750: 7 Days Past Due Conditional Formatting & Logical Formula 5:00 2010-12-07
67 Excel Magic Trick 736: Formula & Conditional Formatting To Show Waste From Cutting Rebar 6:57 2010-11-15
68 Excel Magic Trick 768: Gradebook Average w Criteria and Conditionally Format Less Than 4 Tests Taken 6:26 2011-03-14
69 Excel Magic Trick 769: Adding & Conditional Formatting with NOT Criteria 5:48 2011-03-15
70 Excel Magic Trick 794: Conditional Formatting MAX or MIN or Top 3 Value/s In Row 10:07 2011-06-10
71 Mr Excel & excelisfun Trick 82: Allow Below Limit: Data Validation or Conditional Formatting 6:37 2011-09-09
72 Excel Magic Trick 806: Schedule with Holidays Conditional Formatting & Custom Number Formatting 10:26 2011-09-27
73 Excel 2010 Magic Trick 820: Conditional Formatting With Array Formulas!!?? 10:03 2011-10-21
74 Excel Magic Trick 823: Conditional Formatting Row, Column, Intersecting and Specific Table 2 Methods 18:57 2011-11-13
75 Excel Magic Trick 835: Drill Through Conditional Formatting Across Sheets Using Format Painter 4:37 2011-12-08
76 Excel Magic Trick 852: Conditional Standard Deviation: STDEV.S & IF or DSTDEV functions? 4:43 2012-01-05
77 Excel Magic Trick 850: Conditional Format More Than 24 Hours (3 Examples) 5:28 2012-01-05
78 Excel Magic Trick 868 Conditional Format Row Not & Between Criteria: Excel Conditional Formatting 3:40 2012-02-07
79 Excel Magic Trick 879: Conditional Formatting Across Worksheet (Sheets or Tabs) 10:22 2012-03-06
80 Excel Magic Trick 897 Conditional Format Row If Brand Field Contains Particular Brand (Partial Text) 4:24 2012-04-02
81 Excel Magic Trick 896: Conditional Formatting Formula: Entire Row Red If SUM Greater Than 45 4:12 2012-04-01
82 Excel Magic Trick 912: Conditional Formatting Minimum Value in Row Ignore Zero and #N/A: AGGREGATE 10:15 2012-05-01
83 Excel Magic Trick 921: COUNTIF Cells Containing Particular Characters: Count & Conditional Format 5:06 2012-05-23
84 Excel Magic Trick 940: Conditionally Format Row "At Each Change In" Grouped Items 3:05 2012-07-05
85 Excel Magic Trick 964: Custom Number Format Show Positive With Plus and Negative With Minus 1:39 2012-08-22
86 Excel Magic Trick 965: Conditional Formatting Green For Correct Multiplication Table Answer 4:03 2012-08-22
87 Excel Magic Trick 966: Conditional Format Row When Item Is In List 5:27 2012-08-22
88 Excel Magic Trick 993: Conditional Formatting Row Where Last Three Numbers In ID Equal 123 3:36 2013-05-08
89 Mr Excel & excelisfun Trick 125: Conditional Formatting Date Four Days Old & Not Paid 7:03 2013-05-28
90 Excel Magic Trick 993: Conditional Formatting Row Where Last Three Numbers In ID Equal 123 3:36 2013-05-08
91 Excel Magic Trick 989: Conditional Formatting For Values above 90% Percentile Mark 3:51 2013-05-04
92 Excel Magic Trick 998: Conditionally Format Products As They Expire 6 Months From Creation Date 4:23 2013-05-31
93 Excel Magic Trick 999: MATCH Rather Than OR function to Conditionally Format Row With OR Criteria 5:10 2013-05-31
94 Excel Magic Trick 1004: Conditionally Format Row With nth Duplicate, Column Sorted or Not Sorted 6:53 2013-06-24
95 Excel Magic Trick 1011: Conditionally Format Row Above Matched Text Criteria "Subtotal" 9:05 2013-07-12
96 Excel Magic Trick 1026: Conditionally Format 1st Occurrence of Yes Vote For Given First & Last Name 6:16 2013-07-26
97 Excel Magic Trick 1045: Conditionally Format Multiple Modes in a Column, Excel 2010 or Later 3:45 2013-08-17
98 Highline Excel 2013 Class Video 48: Conditional Formatting: Bar Chart with Data Labels 2:24 2013-12-22
99 Excel Magic Trick 1059: Conditionally Format Top 5 Numbers That Are Also Greater Than 65 5:11 2013-12-28
100 Excel Magic Trick 1087: OR & IF Function & Conditional Format: Number Outside Lower & Upper Hurdle 9:41 2014-03-27
101 Excel Magic Trick 1086: 3 Way Lookup Formula & Conditional Formatting, Date Criteria Mismatch 10:33 2014-03-27
102 Excel Magic Trick 1106: 3-D Gradient Conditional Formatting For Row with AND Criteria 4:35 2014-05-04
103 Excel Magic Trick 1119: Conditional Format Date when 44 Days Have Passed 5:21 2014-05-30
104 Excel Magic Trick 1124: Conditional Format Sundays & Weekends: NETWORKDAYS.INTL & NOT functions 6:05 2014-06-26
105 Excel Magic Trick 1173: Conditional Format Dates When they are 90 Days of Set Expiration Date 6:58 2015-02-07
106 Excel Magic Trick 1200: Conditional Format Grades To Assign Icons To 1 of 3 Groups (3 Methods) 6:59 2015-05-23
107 Excel Magic Trick 1202: Conditional Formatting For a Cross Tabulated PivotTable 4:06 2015-05-25
108 Excel Magic Trick 1201: Conditional Format Product With No Sales (5 Examples) 10:07 2015-05-24
109 Excel Magic Trick 1204: Conditional Formatting For Day’s Change: Up & Down Icon Arrows 2:52 2015-05-31
110 Excel Magic Trick 1227: Conditional Format: Min, Max & Min Value Greater Than Zero 7:20 2015-08-17
111 Excel Magic Trick 1229 Extract Items NOT in List 1: Conditional Format Unique Values & Sort by Color 2:37 2015-08-19
112 Excel Magic Trick 1230: Conditional Formatting: Highlight Table with Color When Name Selected 5:08 2015-08-23
113 Mr Excel & excelisfun Trick 175: Conditional Formatting to Highlight Cells with Formulas 5:32 2015-11-13
114 Merry Christmas Tree Fun In Excel RAND Function and Conditional Formatting (Excel Magic Trick 1245) 1:54 2015-12-26
115 Excel Magic Trick 1307: Conditionally Format Multiple Non-Adjacent Cells in Cross Tabulated Table 9:00 2016-07-20
116 Excel Magic Trick 1326: Conditionally Format Text Modes: PivotTable, Array Formula or Power Query? 24:51 2016-10-04
117 Excel Magic Trick 1344: Conditional Formatting the Entire Row in an Excel Table: Totally Dynamic!! 6:02 2016-11-13
118 Excel Magic Trick 1345: Conditionally Format Product Name for No Items Entered in Row (4 Methods) 6:29 2016-11-15
119 Sparkling Christmas Tree in Excel! Build Conditional Format Christmas Tree: Excel Magic Trick 1361 2:24 2016-12-25
120 Excel Magic Trick 1400: Conditionally Format Row in Class Enrollment Table with Complex Criteria 10:51 2017-03-31
121 Excel Magic Trick 1400 Part 2: Conditionally Format Row with Complex Criteria (3 More Examples) 19:34 2017-04-02
122 Excel Magic Trick 1401: Conditionally Format Row For BOLD Date 7:27 2017-04-03
123 Excel Magic Trick 1402 Part 5: Conditional Formatting to Show Check Mark When Number Bigger Than 0 2:21 2017-04-11
124 Excel Dynamic Arrays & Conditional Formatting for Spilled Arrays (Excel Magic Trick 1525) 5:14 2018-11-04
125 Excel Conditional Format Row, Column & Intersecting Cell - Excel Magic Trick 1572 4:39 2019-07-22
126 Excel Formula: Count Matches in Both Lists. Conditional Formatting to Format Matches. EMT 1613 3:47 2019-10-22
127 Count NOT “Apple” with Excel Formula & Conditional Formatting - Excel Magic Trick 1630 2:37 2019-12-27
128 Extract Data From Cell, Display Horizontally with Excel Formula. 5 Examples. Excel Magic Trick 1663 6:49 2020-04-28
129 Excel Conditional Formatting Weekend & Holiday Date for Row in Table. Excel Magic Trick 1680. 6:02 2020-07-27
130 Action Packed XLOOKUP Video: 3-Way Lookup, Cell Reference Lookup, Conditional Formatting. EMT 1695. 9:38 2020-10-13
131 Conditionally Format When Two Columns have Same Value. Excel Magic Trick 1704. 1:51 2020-11-27
132 Formatting Dynamic Spilled Array Formulas so that Formatting Follows Spill! Excel Magic Trick 1723 4:12 2021-02-12
133 SUMIFS with Dynamic Data Validation List & Conditional Formatting for Row. Excel Magic Trick 1739 5:56 2021-06-08
134 Excel Conditional Formatting for a Chess Board or Checkerboard. Excel Magic Trick 1754 4:46 2021-09-17
135 Conditional Formatting to Highlight Missing Sequential Incident Numbers. Excel Magic Trick 1766 11:09 2021-12-15
136 Excel Flashing Christmas Tree 2021- Happy Holidays Old School Formula Method. EMT 1768 2:18 2021-12-25
137 Duplicates in Row? Conditional Formatting, Counting and Logical Formula. Excel Magic Trick 1793 8:39 2022-06-14
138 Excel Formula to Lookup Cell Address Of Max Value: 12 Amazing Examples. Excel Magic Trick 1794 9:55 2022-07-05
139 Conditional Formatting for Consecutive Numbers with Logical Formula. Excel Magic Trick 1806 4:06 2022-12-07
140 Conditional Format Row When Employee Is Listed More Than 1 Time For Date. Excel Magic Trick 1821. 3:09 2023-06-14
141 Multiple 2-Way Lookup Intersecting Values Conditional Formatting XMATCH Logical Formula. EMT 1889 3:56 2025-05-04
142 Conditionally Format Row in Schedule for Today’s Date - Mixed Cell References | EMT 1924 5:59 2026-08-09

Embed a badge

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

Watch time: 17h 59m · 142 videos

Markdown
[![Watch time: 17h 59m · 142 videos](https://playlistduration.com/badge/playlist/PL2ACA26D4485F8EDD.svg)](https://playlistduration.com/playlist/PL2ACA26D4485F8EDD)
HTML
<a href="https://playlistduration.com/playlist/PL2ACA26D4485F8EDD"><img src="https://playlistduration.com/badge/playlist/PL2ACA26D4485F8EDD.svg" alt="Watch time: 17h 59m · 142 videos" width="217" 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/PL2ACA26D4485F8EDD 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.