I've compiled a spreadsheet of part numbers our company has at an off-site
warehouse, and to make reading this sheet easier, I'm trying to figure out a
way to alternate the background color of the rows based on the part number.

There may be six rows of one part number, then four rows of the next part
number, then ten rows of the next. I don't want to alternate the colours of
every other row because that has no logical relationship to the data. I want
the rows of the same part number to be the same color as each other, and then
to switch to an alternate color for the next part number's rows, and then
switch back to the first color for the folowing part number's rows, so all
rows of a unique part number are grouped by color and easily seen at a
glance. Is this even possible at all?

I've looked into conditional formatting, but I can't figure out what would
be needed to scan for occurrences of a part number, color them all the same,
then switch to a second color when the part number changes, and then switch
back to the first color when the part number changes again. I may be
attempting to do soemthing that just isn't possible. Does anyone have any
ideas?

Thanks!