Why I receive an error at the line:
".Interiorcolor.Index = 2" ?
Can somebody help me?
Many thanks.
While Cells(x, 1).Text <> ""
If Cells(x, 3).Value >= Cells(x, 4).Value Then
With Cells(x, 3)
.Interior.ColorIndex = 6
End With
Else
With Cells(x, 3) And Cells(x, 4) And Cells(x, 5) And Cells(x, 6) And Cells(x, 7) And Cells(x, And Cells(x, 9) And Cells(x, 10)
.Interior.ColorIndex = 2
End With
End If
".Interiorcolor.Index = 2" ?
Can somebody help me?
Many thanks.
While Cells(x, 1).Text <> ""
If Cells(x, 3).Value >= Cells(x, 4).Value Then
With Cells(x, 3)
.Interior.ColorIndex = 6
End With
Else
With Cells(x, 3) And Cells(x, 4) And Cells(x, 5) And Cells(x, 6) And Cells(x, 7) And Cells(x, And Cells(x, 9) And Cells(x, 10)
.Interior.ColorIndex = 2
End With
End If