I am checking to see if the value in column B is greater than the value of Column C. If the cell is empty, then I want the macro to skip to the next cell in the loop. When I write "next i" it errors "next without for". I know there are options to use GoTo or Case Select, but I couldn't get the syntax right on that either. Any suggestions?


Sub SKIP_ifcell_empty()

Dim i As Integer

For i = 2 To 1000

If Cells(i, 3).Value = Empty Then
next i 
End If

If Cells(i, 2).Value > Cells(i, 3).Value Then
Cells(i, 2).Interior.Color = 3000
End If



Next i

End Sub