Finally, it’s time to create the conditional format rule that fills alternating groups in the Excel Table: Select the data, B3:F13. (Don’t include the column of consecutive values in column H.) ...

Before you can set the conditional format, remove the subtotaling rows by clicking Subtotal (Data tab) and clicking Remove All. Assuming you want the entire row formatted, select the data set, B3 ...