Conditional Formatting

[aposatsk]

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

...
Smith, John
Smith, John
Johnson, George

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 Noob

[daddylonglegs]

Select A2:A200

use CF with "formula is"

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