title: vba how to check if a cell has no formatting or color
body: <p>I recently had a question regarding how to copy a cell value into all cells below it and stop based on when column A got to a blank cell.  <a href="https://stackoverflow.com/questions/17843905/vba-macro-copy-cell-value-to-all-cells-below-it">post</a> </p>
  
  <p>The excel sheet I'm working in has many divider rows that are color filled across the entire row to separate categories as you scroll down the sheet.  I would like to be able to skip these separating rows in column A when the macro checks for a blank cell in column A.  Or I would like to just assign StopRow to the first cell which has no formatting/no color/no value.</p>
  
  <p>Here is what I have, thanks to Ripster earlier today, but I've failed incorporating a proper if then statement with what he came up with.</p>
  
  <pre><code> Sub Example()
      Dim MasterValue As String
      Dim StopRow As Long
      Dim i As Long
  
      'Get the master value
      MasterValue = Range("C5").Value
  
      'Get the first blank cell in column A
      StopRow = Range("A1").End(xlDown).Row
  
      'Start at row 6 and continue to the "Stop Row"
      For i = 6 To StopRow
          'Set every cell from row 6 in column 3 to the "Master Value"
          Cells(i, 3).Value = MasterValue
      Next
  End Sub
  </code></pre>
  
  <p>Please help.
  <img src="https://i.stack.imgur.com/nyz7o.jpg" alt="IE"></p>
  
  <p>Thanks</p>