I'm looking to highlight duplicate rows of data based on column A.
The comparison must be case sensitive.
So
blah
blah
are duplicates
Blah
blAh
are not duplicates.
Currently I can use the default conditional formatting function to find duplicates. However it is not case sensitive. Regardless of upper or lower case, if the exact phrase is there it thinks they are duplicates.
Is there a method to also search for duplicates and highlight them but take in to account the case as well?
Thx
Bookmarks