Excel Magic Trick 1400 Part 2: Conditionally Format Row with Complex Criteria (3 More Examples)

4,531 views · Published 2 April 2017 · 19:34 · Indexed 21 October 2026

Channel: excelisfun · 2017 · Education

Watch on YouTube

Download Files:

https://excelisfun.net/files/EMT1400%20Part%202.xlsx

https://excelisfun.net/files/EMT1400%20Part%202-Timing.xlsm

See 3 formula solutions for how to Conditionally Format the row in an Enrollment Table when the following conditions are met: 1) Enrollment less than 15, 2) then format row, Name Column can NOT contain: 'Introduction', 3) Department can NOT be: NURS OR MTH:
1. (00:11) Introduction 
2. (01:23) Example 1: COUNTIFS formula from Dean Bailiff
3. (08:10) Example 2: PRODUCT Array Formula from Bill Szysz
4. (14:00) Example 3: Helper Column Formula from Dusty Wilson.
5. (17:05) Timing of all the methods
6. (19:19) Summary

More from this channel

• 3:51 YouTubersLoveExcel#19: Steady Growth Cash Flow Formula

  excelisfun

  3,560 views · 23 May 2008

• 3:44 YouTubersLoveExcel#26: Text To Column Trouble

  excelisfun

  3,596 views · 30 May 2008

• 3:41 YouTubersLoveExcel#26.2: Formulas do not like TEXT Time

  excelisfun

  2,016 views · 6 June 2008

• 3:30 YouTubersLoveExcel#34: Hide Columns Copy Problem

  excelisfun

  3,877 views · 11 June 2008

• 9:27 YouTubersLoveExcel#31: Dates, Cash Flow & Logic

  excelisfun

  4,909 views · 11 June 2008

• 1:57 YouTubersLoveExcel#36: VLOOKUP increase based on Rating

  excelisfun

  3,053 views · 16 June 2008

• 7:38 YouTubersLoveExcel#52: VLOOKUP & Workbook References

  excelisfun

  3,914 views · 7 July 2008

• 1:39 YTLE#60: Hide Columns by Grouping

  excelisfun

  4,807 views · 18 July 2008