title: Need to copy date from one column into another column for a range of rows between two different colored rows
body: <p>I am admittedly a VBA noob who needs some major help trying to figure out the following.</p>
  
  <p>So in my data set I have rows with green backgrounds and rows with red backgrounds.</p>
  
  <p>I need to take the date and time from column S in the row with the green background, and copy it into column D for each row between the green row and the red row, inclusive of the colored rows. </p>
  
  <p>I then need to take the date and time from column s in the row with the red background, and copy that into column E for each row in the same range, again inclusive of the colored rows.</p>
  
  <p>This needs to be done multiple times per sets of data with a variable number of rows between the green row and the red row each time. </p>
  
  <p>I am thinking that it makes sense to use the R1C1 cell addressing instead of the A1. What I am specifically lost with is first of all, how to detect the background color of each cell, and secondly, how to count the number of rows between the green and the red cells, and thirdly how I go about reading from row to row. Am I simply treating it like an array of known size?</p>
  
  <p>I am new to VBA with Excel and am admittedly struggling with quite a bit here. I am looking through various books, tutorials, etc, but I could REALLY use some help!! </p>