title: Need a macro to detect if cell value changes from current value
body: <p>I need help with an macro to notify me (by changing a cell background color to red), when the value (always number format) changes in any cells in the row. I want the background of cell E3 to change to red, if any of the values in cells F3:AN3 change from their current values. </p>
  
  <p>The numbers in cells F3:AN3 will be entered manually or thru copy and paste of the row, and there won't be any formulas. Likewise, if any values in cells F4:AN4 are changed, I would like cell E4 to change to a red background, and so on for each of the rows in the chart. Not all rows will always have a value, so I would be looking for changes from "" to any #, or from one # to another #, or from any # to "". Ideally this would be an event macro that does not have to be run manually.</p>
  
  <p>The following is the code I've started working with:</p>
  
  <pre><code>Private Sub Worksheet_Change(ByVal Target As Range)
      If Not Intersect(Target, Range("F3:AN3")) Is Nothing Then KeyCellsChanged
  End Sub
  
  
  Private Sub KeyCellsChanged()
  
     Dim Cell As Object
       For Each Cell In Range("E3")
      Cell.Interior.ColorIndex = 3
  
     Next Cell
  
  End Sub
  </code></pre>
  
  <p>However, this macro seems to run regardless of whether the number in the cell is changed, as long as I press enter it highlight E3 as red.</p>
  
  <p>Any help is much appreciated!</p>