Conditional formatting to find duplicates

[rcraps]

I am looking to find duplicates across several worksheets inside of one workbook. I have a list of course numbers from what the students have signed up to take and want to compare that to each individual department's course codes to verify that all are accounted for etc.

I have tried many things but admittedly I don't use conditional formating very much. Any ideas?

 

[mole999]

can you post a sample of your data ?

 

[asyamonique]

http://www.mrexcel.com/forum/showthread.php?t=345201

Have a look that link.
Can be target for multiple sheets as well.

 

[rcraps]

can you post a sample of your data ?

This is the best that I was able to find to do.
http://dl.dropbox.com/u/4502350/Course Tally March 4 2011.xlsx

The above link should take you to the actual file. I am trying to figure out a way to verify that all the course numbers under the "numbers" tab are located on all the other sheets. My "numbers" total is not matching the sum of the remaining sheets, and they should if everything is accounted for.