Highlight only the second instance of a duplicate

T

TMck

Hello, I am trying to apply conditional formatting to a list where
only the second and subsquent duplicates should be highlighted. I've
tried =COUNTIF($A$2:$A2,A2)>1 and several other variations but they
all result in highlighting the first result, which is the opposite of
what I want. Any suggestions?
Thanks!
Tiffany
 
D

Dave Peterson

I think you either posted the wrong formula or you did something wrong in your
worksheet.

Your conditional formatting formula worked fine for me when I tested it.

One more question...

Did you select the range and apply the formula to all the cells in that
selection at once?

Did you make sure that the cell that was active in the selection was A2?

I'd try it once more (maybe in a new worksheet/workbook???).
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

error in highlighting duplicate values in excel 1
Conditional Formatting Based On Formula Values 2
Show a message if there are some duplicates 1
VBA to Find Word or Phrase then Highlight Entire Paragraph that Follows 5
Separating Duplicates?? 2
conditional formatting formula to highlight items on column B inrelation to column A 4
Formating bolded text exclusively. 0
Need help modifying code 0

Top