Highlight only the second instance of a duplicate

  • Thread starter Thread starter TMck
  • Start date Start date
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
 
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???).
 
Back
Top