With the helper column in place, it’s time to add the conditional format rule. The Excel rule highlights odd-numbered groups. (See the values in column H.) Keep in mind that you will need to re ...

Getting Excel to expand each band to accommodate groups doesn’t require a mind reader. In this case, we want the band to expand for each region. To accomplish this, we’ll add a helper column ...