Duplicates Conditional Formatting

I need the cells in a column (Range) to highlight if they are duplicate numbers only and ignore any text. I tried =countif(A2:A10,A2)>1 and then formatted it to highlight red just to see it highlight duplicates and all it did was highlight every cell within that range red. So what formula would I use in conditional formatting to highlight only numeric duplicates?


Thanks,
Jay

Jay,

any chance you could post a data sample in an Excel workbook to go with your formula? Otherwise, how are we to determine what the result should be?

=and(isnumber(a2),countif($a$2:$a$10,a2)>1)