duplicated names on a list problem

[Bob@Sun]

I have the following problem, I have a list of names which requires to be updated on a daily basis. I want to know if there is a way to highlight the cell if the newly entered name coincides with an already entered one previously in the column. An exact VBA code would be helpful.

[royUK]

See this