Excel Forum
Similar Content
Better Edit Excel Formulas in the Conditional Formatting Window or Name Manager
Tutorial: Excel quickie tutorial that will show you a great tip for working with formulas within th...
8 Tips to Become an Expert in Conditional Formatting for Excel
Tutorial: Become a master of Conditional Formatting in Excel! This tutorial covers 8 tips and trick...
Multiple Conditional Formatting Rules for a Cell in Excel
Tutorial: Apply multiple Conditional Formatting rules to a cell or range in Excel. This allows you ...
Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course



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


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.





Got a Question? Ask it Here in the Forum.