hi
I have many items are repeated between two columns A,B what I want highlighted the duplicated data between tow columns
if the items are duplicated in the same column or in another column with all the same spaces not different in spaces should highlighted by blue color and if the items the same elements but the different in spaces then should highlighted by green color the items contains letters ,digits and symbols if can do that without loop it will be a great
I put the result in second sheet
Bookmarks