Duplicates in the same column are easy to find by sorting, filtering, and using conditional formatting. When none of those are an option, try this simple formula solution.

Use a logical OR operator in conditional formatting The equality operator we used in the last section was easy to implement, but it doesn’t work as expected when applied to a single-column range.