title: Excel VBA - Highlighting pairs of positive and negative numbers
body: <p>Suppose I have a column of numbers, for example:</p>
  
  <blockquote>
    <p>1; -1; 5; 4; 3; -3; -3; 3; -4; 7.</p>
  </blockquote>
  
  <p>I want to make a macro that can highlight all pairs of positive and negative numbers (ex. 1 and -1) while also taking in consideration the fact that multiple pairs can appear (ex. 3 and -3 both appear twice). Also, I want to be able to input the range that I want to work with.</p>
  
  <p>For the above example, all numbers should be highlighted except 5 and 7.</p>
  
  <p><strong>Here's what I came up with so far</strong></p>
  
  <pre><code>Sub HighlightExercise()
  
  Set myRange = Application.InputBox(prompt:="Sample", Type:=8)
  
  myRange.Interior.ColorIndex = 2
  
  For Each cell In myRange
  
  If cell.Interior.ColorIndex = 30 Then Next
  
  Set CValue = Cell.Value
  
  myRange.Select
  
  Set CFind = Selection.Find(What:=CValue.Value * -1, After:=ActiveCell, LookIn:= _
      xlFormulas, LookAt:=xlWhole, SearchOrder:=xlByRows, SearchDirection:= _
      xlNext, MatchCase:=False, SearchFormat:=False)
  
  If CFind.Value = Null Then Next
  
  If CFind.Interior.ColorIndex = 30 Then Next
  
  CFind.Interior.ColorIndex = 30
  
  CValue.Interior.ColorIndex = 30
  
  Next
  
  End Sub
  </code></pre>
  
  <p>In the above example, it says "Compile error, Next without For" yet the For condition is there. I tried with "Next Cell" and "Next iteration" but still nothing. What am I not getting?</p>