conditional formatting- same value, different columns

[wynand]

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?

 

[Bob Phillips]

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]

the reference cell (A2), is in not in the same column but rather in coulumn D:
COUNTIF(A$2:A$200,A2)>1
so if I use COUNTIF(A$2:A$200,D2)>1
it does not work

 

[Bob Phillips]

Post a sample data layout, it is not clear at the mo'.

--
---
HTH

Bob


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

 

[wynand]

AA BB
1) 111 444
2) 222 555
3) 333 111
formula should shade A1 and B3