Quote Originally Posted by martindwilson View Post
=and(isnumber(a2),countif($a$2:$a$10,a2)>1)
Awesome! Worked perfectly. Thanks!