How do I shade every 7 rows in Excel?
Step 1: Provide the data in the table. Step 2: Highlight the entire data and apply conditional formatting. Step 3: While formatting, apply the formula =ISODD(CEILING(ROW()-5,3)/3) Step 4: Press “Apply and the “Ok” to apply the conditional formatting.