Check if a list have the same element in Excel-CodePudding

I would like to check if in Excel column I have two same element.
Basically my aim is to write every time a word in a new cell but I want excel to advise me if I already put the same word.

Something like this:
If I am writing again "dog" I want excel to tell me something.

Thanks in advance :)

CodePudding user response：

For Excel 2016

Highlight the entire column
Click on "Home"
Click on "Conditional Formatting"
Click on "Highlight Cells Rules"
Click on "Duplicate Values"
Click on "Ok"

Now enter dog in same column, both instances of "dog" will highlight red.

CodePudding user response：

That's built-in!
See: Conditional formatting / highlight cell rules / Duplicate values