Hi,
I would like to highlight case sensitive duplicate ID's in column A. In this example the difference is the "h" or "H", everything else is the same 00000khK72 OR 00000kHK72 and therefore should not receive conditional format, only exact match, with the same "H" should be highlighted. Standard conditional formatting ignores the case and formats both the 00000khK72 AND 00000kHK72 as being duplicates and they are not.
Any help is greatly appreciated.
Thanks