title: Populate column until text changes in colored cells
body: <p>I have about 100,000 lines of data in Excel and some coloured cells in column C which I want repeatedly to populate in column B up until the coloured cell contains different text, when I want to populate that different text, etc.  Example below:-</p>
  
  <p>Before:</p>
  
  <p><a href="http://i61.tinypic.com/24q758n.png" rel="nofollow">http://i61.tinypic.com/24q758n.png</a></p>
  
  <p>After:</p>
  
  <p><a href="http://i59.tinypic.com/t6as9l.png" rel="nofollow">http://i59.tinypic.com/t6as9l.png</a></p>
  
  <p>Are there any macros, VB scripts or "IF" statements I could use? It seems like a life time's work if done via copy 'n paste.</p>