Highlight Name List Used More than twice

[tlbgto]

I have a list of names and I want to highlight the names that are used more than twice. I know conditional formatting will find duplicates, but I need the ones that or used more than twice.

 

[Snakehips]

tibgto,

Maybe like....

Excel Workbook
	A
1	Names
2	Tom
3	Fred
4	Tom
5	Sid
6	Bill
7	Tom
8	Charlie
9	Sid
10	Bill
11	Sid
12	Frank
13	Charlie
14	Frank
15
Sheet1

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
A2	1. / Formula is =COUNTIF(A:A,A1)>2	Abc

Hope that helps,

 

[tlbgto]

Worked great thanks.