View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
aposatsk aposatsk is offline
external usenet poster
 
Posts: 1
Default 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