Excel Forum



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.