Finding duplicate values (or unique values)
with Conditional Formatting
Back to conditional formatting menu
Try it yourself