Conditional Formatting/Duplicates

Hi,

Check
http://www.excelforum.com/excel-prog...her-sheet.html
and look at Filters.xls.
The code look at dupes and moved the dupe to another sheet.
If there was only 1 occurrence of the data it was not copied to the other sheet.

Thank you very much, Charles.

However, running the macros results in run-time Error 1004, on this line:

Please Login or Register  to view this content.

I note that Option Explicit is off and that the code is very sloppy. I'll keep searching for similiar code which works.

I think I see the gist of it, but I'm still not there.

Many thanks.

Hello vba-dev,

Your profile says you use Excel 2003. The workbook you posted in Excel 2007 format which is probably what you use at work. You will get more responses if post a copy of the workbook in 2003 format also. Unless there is some backward compatibility problems that prevent this.

Hello vba-dev,

The workbook opens in 2003. Sheet1 has has "Team", "Date 1", and "Date 2". Is that all the data? Sheets 2 & 3 are blank.

Yes, Leith, that's it. It is as I received it from the gentleman who asked me to help him with the above issue.

Sorry the code did not work for you. It did and does work at my end.

Now, I'm not one to complain and I do the what I can to help others.
So I'm a little offended by this.

I note that Option Explicit is off and that the code is very sloppy. I'll keep searching for similiar code which works.

Ok,

Thought I'd give this another go.
Modified code so that it will look for Dup's in column B and at same time see if dups in column C. If there are dups in columnC then highlite.
Did not set code to look at column D.

Examine Column 1 and, for each like value, examine Columns 2 and 3 for duplicate values. Highlight or conditionally format the duplicates in Columns 2 and 3 (again, for each like value in Column 1).

I still can't figure out what you're trying to do...

Search column 1 for like values... Does that mean ONLY in column 1, so if there are 10 duplicates in column 2, but only 1 occurance in column one, then ignore/continue?

Examine columns 2 and 3 for duplicate values... Does that mean duplicates between column 2 and 3, or within only 2, then within only 3, or is it duplicates of the values that were duplicates in column 1?

Format the duplicates in columns 2 and 3 (again, for each like value in column 1). So we're not doing anything to column one, we're only formatting columns 2 and three dependant upon... whatever it's dependant upon?

Would you be able to post an example of your expected results if you were to do this manually? Posting a workbook with nothing in it but data, leaves us guessing multiple times with code variations until we happen to get what you want.

Oh, and an observation:

I assumed it was borrowed from a web site

You do know that people create websites right? So if it's on a website, it's made by a person? You'll likely find code written by various people who frequent this site on "Websites".