title: Color Entire Row Based on Cell Value
body: <p>I'm trying to color an entire row if two cells in that row have the same value.</p>
  
  <pre><code>For i = 2 To LastRow
      If Worksheets("Request Results").Cells(i, 4).Value &lt;&gt; Worksheets("Request Results").Cells(i, 6).Value Then
          Cells(i, 1).EnitreRow.Interior.ColorIndex = 255
      ElseIf Worksheets("Request Results").Cells(i, 4).Value = Worksheets("Request Results").Cells(i, 6).Value Then
          Cells(i, 1).EntireRow.Interior.ColorIndex = 5296274
      End If
  Next i
  </code></pre>
  
  <p>The loop goes into the else statement first and I get</p>
  
  <blockquote>
    <p>"Subscript out of range"</p>
  </blockquote>
  
  <p>on</p>
  
  <pre><code>Cells(i, 1).EntireRow.Interior.ColorIndex = 5296274
  </code></pre>