Excel Magic Trick 621: Conditional Formatting Unique Items With One Criteria

3,851 views · Published 4 June 2010 · 8:38 · Indexed 27 September 2026

Channel: excelisfun · 2010 · Science & Technology

Watch on YouTube

Download Files:
https://people.highline.edu/mgirvin/YouTubeExcelIsFun/EMT615-622.xlsm

See how to add a logical formula that uses the AND and COUNTIFS functions with Mixed Cell References in the conditional formatting dialog box to highlight entire row (whole record) in data set (table) when record is Unique and matches the stated criteria.

More from this channel

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

  excelisfun

  3,557 views · 23 May 2008

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

  excelisfun

  4,807 views · 18 July 2008

• 8:18 YTLE#80: Conditional Format MATCH & INSUMBER functions

  excelisfun

  3,669 views · 4 August 2008

• 4:16 YTLE#82: Enter UPPER Case Text Only Into The Cell

  excelisfun

  2,676 views · 7 August 2008

• 3:22 YTLE#93: "Go To Special Blanks" Caveat

  excelisfun

  1,663 views · 12 August 2008

• 6:24 YTLE#104: Find 1st Positive# in Excel List

  excelisfun

  3,872 views · 30 August 2008

• 4:50 YTL Excel #123: Array Formula To Count E-mails

  excelisfun

  2,540 views · 11 September 2008

• 0:03 Family At Christmas Tree

  excelisfun

  4,723 views · 3 January 2009