To highlight the 3rd entry of the same team:

1. Go to "Format/Conditional Formatting"
2. For Condition 1, choose "Formula Is"
3. In the formula box, enter =countif($A$2:A2,A2)2
4. Click on "Format"
5. Choose your highlighting color (Color box is somewhere in the
middle)
6. Click "OK"
7. Click "OK"

Hope this works for you.

Regards.


--
BenjieLop


------------------------------------------------------------------------
BenjieLop's Profile: http://www.excelforum.com/member.php...o&userid=11019
View this thread: http://www.excelforum.com/showthread...hreadid=394615