Shade/Band Duplicate Rows Together

[canthony24]

I am trying to figure out how to band similar rows together and alternate the color. I would like it to looks like this example...

https://imgur.com/a/LK4jA7o

As you can see, each row is alternating color based on the name. Some are duplicates.

Ideas?

 

[sijpie]

The easiest is with a extra column (which you can hide) with the formula (assuming your example)

in column F, cell F7

=IF(AND(A7=A6,B7=B6,C7=C6,D7=D6,E7=E6),F6,NOT(F6))

and copy this down.

Highlight the range A7:Exx, and give it one of the two background colours.
Then in conditional formatting, with the range still selected, select from Formula and enter:

=$F7=TRUE

Then select the other colour for background. Press enter a few times and you should have the banded sets.