title: Excel, shading every other row(s) based on merged rows in a specific column
body: <p>I am formatting a large survey and need to shade every other question in the first column light blue. But each question has a different number of sub-question rows asking about various factors. Each one of these higher-order questions has a changing number of rows.</p>
  <p>How can I scale the shading of these questions in the A column across the worksheet without me needing to highlight each group and fill it manually?</p>
  <p>Thanks!</p>
  <p><a href="https://i.stack.imgur.com/7jXhc.png" rel="nofollow noreferrer">enter image description here</a>
  P.s. The question numbers are random and do not count up sequentially.</p>