Custom highlight duplicate values ignoring value on top

[Mr.Karr]

Hello

Can anyone pls provide a code snippet to highlight duplicate values but leaving the first value or the top-most string untouched/not to highlight.

Example: I have below list and I want to select everything excel A1, A5, A10

Norway
Norway
Norway
Norway
Portugal
Portugal
Portugal
Portugal
Portugal
Mexico
Mexico
Mexico
Mexico
Mexico

Thanks in advance
Karthik

 

[Somendra Misra]

Hi Karthik,

See this file, EXCEL CF is used and no VBA.

Regards,

 

[Mr.Karr]

thanks SM @Somendra Misra
that's a genius response!

 

[Somendra Misra]

@Mr.Karr

You are Welcome!!!

Regards,

 

[NARAYANK991]

Hi Karthik ,

If your data is exactly the way you have shown in your original post i.e. if all like items are together , then the simplest way is to select the range from the second cell till the end of the data range , and use the formula :

=($A2=$A1)

assuming your data is in column A.

If your data is in random order you will need to use COUNTIF.

Narayan