title: Worksheet Change Event with minimum % Difference
body: <p>I have a worksheet change event.</p>
  
  <p>Original Code:</p>
  
  <pre><code>Private Sub Worksheet_Change(ByVal Target As Range)
     If Range("J12") &lt; Range("G12") Then
        MsgBox "Oppps. Your system is not working!"
     End If
  End Sub
  </code></pre>
  
  <p>I am trying to expand upon the code to:</p>
  
  <p>a. Increase the range from single cells (J12 and G12) to an extended cell range (J12:42, G12:42).</p>
  
  <p>b. Instead of having the change event triggered by less than (J12 &lt; G12), have it triggered by a % difference between J12 &lt; G12.</p>