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

Here are my top 10 secrets for managing lists of data using Excel Tables. 1. Create a Table in Any of Several Ways You can create a table from the Insert tab or (as here) from the Home tab, where ...