conditional formatting- same value, different columns
 

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?

conditional formatting- same value, different columns
 

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?

conditional formatting- same value, different columns
 

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" wrote:

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?

conditional formatting- same value, different columns
 

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" wrote in message
...
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" wrote:

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?

conditional formatting- same value, different columns
 

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


"Bob Phillips" wrote:

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" wrote in message
...
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" wrote:

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?