Re: highlight duplicate rows with fixed range
highlight duplicates and autofilter by colour
My data
1 2
1 4
2 5
3 7
1 2
In this 1 is a duplicate in coloumn A and 2 is a duplicate in coloumn B so highlight the same and after that autofilter it by colour only this much process i need My data is big so use As long in the code can it be possible