At a loss........
Trying to highlight multiple rows to gray where there is a set of duplicate part numbers then let the next part number(s) stay white in an effort to make it easier to read. I can't combine the rows because each line is a different location.The report is imported from a Warehouse system,(Sheet1) which has empty row between part numbers.
I even copied it over to Sheet 2 and sorted to get rid of blanks. The report is to long for Conditional formatting this example is just a small part of the file. We run this regularly and takes hours for someone to do. The closest I've gotten is getting every other row to highlight???? the column I'm keying or using is "M".

Any help would be appreciated!