title: How to sum a series of cells until cell color then continue after cell color for rest of range in VBA?
body: <p>I am trying to determine the sum of the data points between cells that have been conditionally formatted (GREEN) based on their values. </p>
  
  <p>I'm not sure where to start my VBA code to sum all of the WHITE cells before a GREEN cell and place that sum in another location (ex. "A66") then sum the WHITE cells between the first GREEN cell and the second GREEN cell and place that in "A67". </p>
  
  <p>I would like the code to continue summing the white cells until it gets to a green cell and then stop, place that summed value in a cell, then start a new sum for the white cells after the green cell that just caused the code to stop until it gets to the next green cell and place that value in a cell below, repeat. </p>
  
  <p>I am NOT trying to sum all of the white cells in the range as a total.
  <a href="https://i.stack.imgur.com/GMbwP.png" rel="nofollow noreferrer">Data Sheet</a></p>