| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| conditional formatting for key-value columns | New Users to Excel | |||
| Can you add conditional formatting to columns that are linked? | Excel Worksheet Functions | |||
| Conditional Formatting-Comparing Two Columns | Excel Discussion (Misc queries) | |||
| Conditional Formatting-Comparing Two Columns | Excel Discussion (Misc queries) | |||
| Conditional Formatting 4 Columns | Excel Discussion (Misc queries) | |||
Linear Mode
