Am getting that compiler error on this very simple code:
I wrote 10 numbers in column A including a "50" so it could turn red. I tried it on a new sheet as well and I'm can't see the problem
Code:
Sub app()
finalrow = Cells(Rows, Count, 1).End(xlUp).Row
For x = 1 To finalrow
If Cells(x, 1) = 50 Then
Cells(x, 1).Interior.ColorIndex = 3
End If
Next x
End Sub
I wrote 10 numbers in column A including a "50" so it could turn red. I tried it on a new sheet as well and I'm can't see the problem