Conditional Formatting

[aposatsk]

I have a chart of more than one column. The first column holds name
starting at A2 in aplha order. I need to scan from A2 onwards (to A20
for example) and highlight the cells that are duplicates (or tripl
copies). For example

..
*Smith, John
*Smith, John
Johnson, Georg

In this list, Smith, John will highlight

 

[VBA Noob]

Try this

=IF(COUNTIF($A$2:$A$100, $A1)>1,TRUE,FALSE)

This site should help

http://www.cpearson.com/excel/duplicat.htm

VBA Noo

 

[daddylonglegs]

Select A2:A200

use CF with "formula is"

=COUNTIF(A$2:A$200,A2)>