An Excel conditional format that expands with grouped data

By adding a helper column and a simple conditional format rule, you can apply an alternating band scheme that expands to accommodate a group.