Highlighting Rows by Criteria and Finding Duplicates in Excel
I'll show you how to highlight entire rows based on one or more cell values using advanced conditional formatting, and how to automatically identify and call out duplicates within a table.