Highlight Values with/ without Duplicates in EXCEL

Answer the question: is There a list of values, duplicates? The list can contain empty cells.

Set Conditional formatting to highlight only duplicate values in the list.

Set Conditional formatting to highlight only the distinct values in the list.

Set Conditional formatting to highlight only unique (different) values in a column.

Set up Conditional formatting for allocation among duplicates of only those who meet the first (top).

Set Conditional formatting to highlight only the duplicates. Unique values will not be selected.

Set Conditional formatting to highlight duplicate values that are repeated 3 or 4 times.

Find the number of unique numeric values in the specified multi-column range.

Set Conditional formatting to highlight only the distinct values and is case-sensitive. Ie the values "Smith" and "Smith" will be considered as non-repeatable (different values).