Conditional formatting duplicates with and without wildcard asterix

[holtsmeister]

Problem: I have a column with article numbers. I need to find and highlight any duplicates. This does not work when the number involves wildcards, such as *.

For instance:
123-abc this one is not highlighted
123-abc* this one is highlighted

I need to solve two scenarios.

Scenario 1: I want to highlight duplicate values regardless of character. So I want wildcards to be included.

For instance:
123-abc
123-abc*
None should be highlighted.

Scenario 2: I want to highlight duplicate values while ignoring everything but numbers and letters.

For instance:
123-abc
123-abc*
Both should be highlighted.

My solution for scenario 2 would be to manually remove all special characters, but I need to keep the original description as well. Can be done, but wondering if there is a more elegant way than creating new columns and such.

Thank you so much!

[BMV]

Have you got example in the file?

[holtsmeister]

Sorry. Here's example file.

Needed to update the example too since the one I gave actually gave the correct behavior for scenario 1 for some reason.

[BMV]

Please Login or Register  to view this content.

Please Login or Register  to view this content.

or in name and then in CF

Please Login or Register  to view this content.

[holtsmeister]

Thank you!

I've played around with it but still run into issues. I addeda few more test cases and this seems to break the code. In scenario 1, I added an actual duplicate but there is no highlight. Scenario 2 ignores * at the end of a string, but putting the * in the front doesn't seem to work.

And what is even more annoying. I added another sheet to test your code, but it doesn't work after I copied it to Sheet 2? This one drives me insane!

[BMV]

Could be here "123-*abc"?