title: How to highlight an entire row in Excel when a change to a cell is made using VBA
body: <p>I have a formula that will highlight a cell if something is changed in excel (below) but I wanted to see if I could tweek it a little and make the entire row highlight yellow if a cell is changed? Any ideas?</p>
  <pre><code>Private Sub Workbook_SheetChange(ByVal Sh As Object, ByVal Target As Range)
  If Target.Cells.Count &gt; 1 Then Exit Sub
      Target.Interior.Color = vbYellow
  End Sub
  </code></pre>