I have a list of values in a column. And I keep adding more values to the column. I want to check and highlight the cells with duplicate values. How can I achieve this? I tried with conditional formatting, but there was no such option for duplicates.

Kalpa Pathum Welivitigoda
http://about.me/callkalpa