Highlighting Duplicate Entries in the same Worksheet

Hi all,

I have two lists of 7 digit numbers that start with 'B' (B1234567) and I
need to highlight which ones appear in both lists.

Should be striaght forward but I cant seem to get it to work. I guess it
should be some for of conditional Formatting.

Thanks in advance

Darran

CF with a formula of say

=COUNTIF(A:A,A1)>1

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Darran" <[email protected]> wrote in message
news:[email protected]...
> Hi all,
>
> I have two lists of 7 digit numbers that start with 'B' (B1234567) and I
> need to highlight which ones appear in both lists.
>
> Should be striaght forward but I cant seem to get it to work. I guess it
> should be some for of conditional Formatting.
>
> Thanks in advance
>
> Darran

ASAP Utilities, which is a free add-in easily found by Googling "ASAP
Utilities," makes this an easy job.

After installing the add-in, highlight the range that includes your lists,
and go to "ASAP Utilities/Information/Count Duplicates in Selection." This
will color the cells that contain duplicate data (regardless of order) and
give you a count of duplicates. Easy as pie.


"Darran" wrote:

> Hi all,
>
> I have two lists of 7 digit numbers that start with 'B' (B1234567) and I
> need to highlight which ones appear in both lists.
>
> Should be striaght forward but I cant seem to get it to work. I guess it
> should be some for of conditional Formatting.
>
> Thanks in advance
>
> Darran