Highlighting Duplicate Entries in the same Worksheet

D

Darran

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
 
B

Bob Phillips

CF with a formula of say

=COUNTIF(A:A,A1)>1

--
HTH

Bob Phillips

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

Traveller

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