How do i locate/highlight duplicates ?
 

I'm using excel 2003. I use large S/S and I would like to be able to locate
duplicates easily. I have found a guide on the internet for creating a
conditional format for this purpose but for some reason it doesn't work.

Any help would be much appreciated.

Thanks

How do i locate/highlight duplicates ?
 

Well show us what it is and explain what happens.

--
HTH

Bob Phillips

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

"Lizardking" wrote in message
...
I'm using excel 2003. I use large S/S and I would like to be able to
locate
duplicates easily. I have found a guide on the internet for creating a
conditional format for this purpose but for some reason it doesn't work.

Any help would be much appreciated.

Thanks

How do i locate/highlight duplicates ?
 

See:

http://www.cpearson.com/excel/duplic...tingDuplicates

--
Gary's Student


"Lizardking" wrote:

I'm using excel 2003. I use large S/S and I would like to be able to locate
duplicates easily. I have found a guide on the internet for creating a
conditional format for this purpose but for some reason it doesn't work.

Any help would be much appreciated.

Thanks

How do i locate/highlight duplicates ?
 

"Lizardking" wrote:

I'm using excel 2003. I use large S/S and I would like to be able to locate
duplicates easily. I have found a guide on the internet for creating a
conditional format for this purpose but for some reason it doesn't work.

Any help would be much appreciated.

Thanks


Assuming the column A is the First column you wanna highlight items.

Select the column.
Then goto your conditional formatting.
Change the Cell Value is to Formula is and type in the following

=IF(COUNTIF($A:$A, A1)1,TRUE,FALSE)

Then select the format buttom then Pattern and select your color.
then ok
and Bingo you got the Duplicated Values highlighted :-P Hope this helps you
out...

just change the A to the letter of the column your working with...