Loop Column & Display Variable In Other Column

on the syntax of things in VBA. here's a description of what i'm trying to do:

1) loop through a particular column ("N"), and compare the values (if not blank) with corresponding cells in another column ("V"). i.e. - comparing N1 to V1, N2 to V2, etc...

2) run If, ElseIf statements to display appropriate values in different column ("O"), but on the row that corresponds to the row the values in Step 1 are compared. i.e. - if N1 > V1 then cell O1 = value; if N2 > V2 then cell O2 = value; etc...

here's an example (but obviously not in proper syntax). hopefully someone can help me convert it to Excel VBA:

Function CalculateFR()

Dim Col1 As Column = ColumnN
Dim Col2 As Column = ColumnV
Dim Col3 As Column = ColumnO
Dim Cell As Cell
Dim IndexValue As Integer

For Each Cell In Col1
If Col1 > Col 2 Then
IndexValue = 5
Else If Col1 < Col2 Then
IndexValue = 4
End If
Next Cell

If Not IsEmpty(Cell) Then Col3 = IndexValue

End Sub