I'm trying to color an entire row if two cells in that row have the same value.
For i = 2 To LastRow
If Worksheets("Request Results").Cells(i, 4).Value <> Worksheets("Request Results").Cells(i, 6).Value Then
Cells(i, 1).EnitreRow.Interior.ColorIndex = 255
ElseIf Worksheets("Request Results").Cells(i, 4).Value = Worksheets("Request Results").Cells(i, 6).Value Then
Cells(i, 1).EntireRow.Interior.ColorIndex = 5296274
End If
Next i
The loop goes into the else statement first and I get
"Subscript out of range"
on
Cells(i, 1).EntireRow.Interior.ColorIndex = 5296274
See Question&Answers more detail:os