Hello everyone
I have a great code for Mr. Karedog that highlights the duplicate rows with different colors ... It is working great and wonderful
I need to make some little changes ..
As for the attachment for example the whole range is D2:H11 ..
column D is not important for me as it will not be duplicated .. the columns E:H is the important for me
Columns F:H is no problem .. if all found from F:H are the same so it would be treated as duplicates
The problem is for column E .. the duplicates would be for positive and negative values so (1 and -1 are considered duplicates)
Here' the code and I hope it is clear
Bookmarks