title: Too many iterations: syntax needed to highlight the cell row only after satifsying all criteria
body: <p>I think I have an issue with the order of my <code>For</code> <code>IF</code> and <code>Next</code> statements, I am trying to only highlight the row where all conditions are meet, instead when my code makes it to the highlighting part all rows are individually highlighted and the code seems to run quite slow, I believe I am performing too many iterations?</p>
  
  <pre><code>Sub SWAPS100()
  
  Dim rng As Range, lCount As Long, LastRow As Long
  Dim cell As Object
  
  Sheets("Output").Activate
  
  With ActiveSheet
  
      LastRow = .Cells(Rows.Count, 1).End(xlUp).Row
  
      For Each cell In .Range("E2:E" &amp; LastRow) 'new position
          If cell = "N" Then
          Debug.Print
                              For Each cell1 In .Range("U2:U" &amp; LastRow) 'Secuirty type
                                  If cell1 = "SW" Then
                                      For Each cell2 In .Range("J2:J" &amp; LastRow) 'prior px
                                          If cell2 = 100 Then
                                              For Each cell3 In .Range("I2:I" &amp; LastRow) 'current px
                                                      If cell3 &lt;&gt; 100 Then
  
              'With cell.Interior
          With cell.EntireRow.Interior
          .Pattern = xlSolid
          .PatternColorIndex = xlAutomatic
          .Color = 6382079
          .TintAndShade = 0
          .PatternTintAndShade = 0
          End With
                                                              End If
                                                          Next cell3
                                                          End If
                                                      Next cell2
                                                      End If
                                                  Next cell1
                                                  End If
                                              Next cell
  
  
  End With
  </code></pre>