A ‘Format as Table’ menu will pop up. This will give you a drop-down of table formatting options. I chose to use the middle green format in the Light category. Click for larger image.

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.) ...