conditional formatting- same value, different columns

W

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?
 
B

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)
 
W

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
 
B

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)
 
Top