How about

COUNTIF(A$2:A$200,A2)1


--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)



"wynand" wrote in message
...
Can anyone please assist:
data is in A2:J2000
I want to highlight identical values in different cells
I used the formula =COUNTIF($A$2:$A$183,D559)1
with no results?