title: Conditional, How I can automate the operation?
body: <p>I need that my code can evaluate the value of a few cells and I don't need to change the cell for each answer</p>
  
  <p>I want this process will be automatic </p>
  
  <p>I try with for, but it doesn't work</p>
  
  <pre><code>Sub Test()
  If Range("E5").Value &lt;&gt; "OK" Or Range("F5").Value &lt;&gt; "OK" Or Range("G5").Value &lt;&gt; "OK" Then
      Range("h5").Value = "NOT ACEPT"
  ElseIf Range("E5").Value = "NOT OK" And Range("F5").Value = "NOT OK" And Range("G5").Value = "NOT OK" Then
      Range("H5").Value = "ACEPT"
  End If
  End Sub
  </code></pre>