Highlighting all duplicate values except first instance

[Ankka]

Hello

I need to highlight all the duplicate IP-addresses in my sheet except the first one.

What I did:

I chose the range (F column) -> Conditional formatting -> Highlight cell rules -> Duplicate Values. It highlighted all the duplicate values so i googled how to highlight the duplicate values except the first one so I came across a formula =COUNTIF($F$2:$F2, F2)>1

So I added the formula and now it does not highlight the first duplicate but only the second and not the third and fourth and so on.

What am I doing wrong?

Edit: I have sorted them in order and in one IP-address I have 6 duplicates but it highlights only the last one when I want it to highlight all of them except the first one.

[Fotis1991]

Hi

Try

Please Login or Register  to view this content.

[Ankka]

I tried but it now highlights all of them, the first one also

[Fotis1991]

I don't think so..

[Ankka]

Thank you very much!

The problem was that I did not delete the first rule (Conditional formatting -> Highlight cell rules -> Duplicate Values) and just added the countif formula with that rule still applying.

[Fotis1991]

You are welcome and thanks for the feedback.

As that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED,as per Forum Rule #9. Thank you.

Also, as a new member of the forum, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.