Highlight entire row when duplicate found but leave 1st duplicate blank

Hi

I have a formula which does exactly what I need it to do and that is highlight the entire row when a duplicate is found but to leave the 1st duplicate blank. (using conditional formatting)

The formula I use is

Please Login or Register  to view this content.

I have noticed an error and that is this only works if the duplicates are not together. The below example works ie leaves the 1st "12345" blank, and highlights the last 2. If they are all "12345", it colours them all.

12345
1234
12345
12345

Is there a way to stop this from happening so both scenarios are covered, ie duplicates together or seperated?

Many thanks in advance

Thank you very much for your help.

It worked very perfectly.

Many Thanks