Highlight your range
Conditional Formatting
Formula Is =COUNTIF($A$1:$A1,$A1)1
Click Format button and select Pattern then click OK and OK


"Brurobiney" wrote:

I have column A with over 500 account numbers. What is the formula that will
allow me to see which of those accounts are listed more than once.