VBA to highlight every other group of rows

Hi All,

I am looking for a VBA to highlight a every other set of rows in a data set in grouped by name. I am able to do so by using conditional formatting but being that I will be doing this on a frequent basis, i wanted to see if someone could assist me with creating a VBA code for it. I have attached an example of what I'd to do.

If c2 = c1 then copy row color, if c2 does not equal c1 then highlight row light grey.

Any feedback would be much appreciated!

Thanks!

Mark

Excel Forum Example.xlsx