Conditional Formatting will do what you want.

Starting in A1, select all cells to test, lets say A1:M800

Goto FormatConditional Formatting
Change Condition 1 to Formula Is
Add a formula of =COUNTIF($A$1:$M$800,A1)1
Click Format
Select the pattern tab
Choose a good highlighting colour
exit out

All duplicates will now show in that colour.

Change the range to suit in the formula.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"mj" wrote in message
ups.com...
Hello guys!

I'm really new in using formulas in excel. I badly needed help in
finding duplicates in my workbook.

Here's the scenario: I have one workbook containing 5 worksheets. Each
worksheet has 10-15 columns of data with 600-800 records (row). With
this, I'm having a hard time tracking down the duplicates that
occurred in the whole worksheet. If I'll do it manually it will take
me ages to finish it and I don't have the time to do it. Is there an
easier way to find or highlight duplicates in the whole worksheet and
compare it to the remaining worksheets so I could only have unique
records?

I tried using the countif, IS and MATCH functions (conditional
formatting) in 2-column data but I don't know if the functions would
work in such amount of records. I'm not familiar with macros
either...:-(

If someone could help me, I would deeply appreciate it.

Thanks in advance!