Color

[Max]

I have a round 50,000 records and some of them are duplicate records. I would
like to know how to color simillar records by any color.

 

[Paul B]

Max, have a look here
http://www.cpearson.com/excel/duplicat.htm#HighlightingDuplicates
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2000 & 2003
** remove news from my email address to reply by email **

 

[Ron de Bruin]

Hi max

See Chip Pearson's site
http://www.cpearson.com/excel/duplicat.htm#HighlightingDuplicates

 

[Max]

I did everything that was written there, but it didnt work. what Does Range1
mean in this code "=IF(COUNTIF(Range1, A5)>1,TRUE,FALSE)", and why it says A5?
I highlight the celll form 1-50,000 then I select conditional formating,
then I put the code, I clicked ok, and nothing happend, thanks.

 

[Max]

Thanks I got it working, but I have no idea why it only start from A5, when
I put A1 it doesnt work.

Thanks

 

[Max]

Thanks Paul, very helpful link

Max, have a look here
http://www.cpearson.com/excel/duplicat.htm#HighlightingDuplicates
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2000 & 2003
** remove news from my email address to reply by email **

 

[Ron de Bruin]

Hi Max

Example :

Select A1:A100
Format>CF

Use this formula : =IF(COUNTIF(A1:A100, A1)>1,TRUE,FALSE)
A1 is the first cell in the Range
Choose a color ( Format>Patterns )