Highlight Duplicate Column Cells In Google Sheets

Google Sheets Jun 3, 2021

Assume you have  data like below and want to highlight the duplicate values:

Names
Liam
Noah
Oliver
Elijah
Henry
Alexander
Oliver
William
James
Benjamin
Lucas
Noah

To highlight, click on "Format" and select "Conditional Formatting"

Now select formatting RULE as "Custom Formula" and enter below formula.

=countif(A:A,A1)>1

Tags

Great! You've successfully subscribed.
Great! Next, complete checkout for full access.
Welcome back! You've successfully signed in.
Success! Your account is fully activated, you now have access to all content.