Conditional Formatting
 

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.


--
aposatsk
------------------------------------------------------------------------
aposatsk's Profile: http://www.excelforum.com/member.php...o&userid=36709
View this thread: http://www.excelforum.com/showthread...hreadid=567412

Conditional Formatting
 

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


--
VBA Noob
------------------------------------------------------------------------
VBA Noob's Profile: http://www.excelforum.com/member.php...o&userid=33833
View this thread: http://www.excelforum.com/showthread...hreadid=567412

Conditional Formatting
 

Select A2:A200

use CF with "formula is"

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


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=567412