title: Change Row Color in Excel Range if condition is met in vb.Net
body: <p>In range &quot;A&quot; to &quot;H&quot; I want to change color when condition in H cell is met. My code work, but it change entire row color if I use this one:</p>
  <pre><code>    For Each h In shXL.Range(&quot;A2:H150&quot;).Columns(8).Cells
                  If h.Value &gt; 14 Then
                      h.EntireRow.Interior.Color = Color.FromArgb(251, 254, 138)
                  End If
      Next
  </code></pre>
  <p>Or color changed with shift from H to N, when I use this one:</p>
  <pre><code>For Each h In shXL.Range(&quot;A2:H150&quot;).Columns(8).Cells
              If h.Value &gt; 14 Then
                  h.Range(&quot;A1:H1&quot;).Interior.Color = Color.FromArgb(251, 254, 138)
              End If
  Next
  </code></pre>
  <p>How to do it?</p>