hi, guys
i would help about this error 1004 see the image
i have data in column b,c,d,i,j,k if some cells in i,j,k contains values more than values in b,c,d then colored yellow in columns,i,j,k
Code
Sub My_code()
Dim i%
Range("i2", Range("j2", Range("k2").End(4))) _
.Interior.ColorIndex = xlNone
i = 2
Do Until Range("i", Range("j", Range("k") & i)) = vbNullString
If Range("i", Range("j", Range("k") & i)) > Range("b", Range("c", Range("d") & i)) Then _
Range("i", Range("j", Range("k") & i)).Interior.ColorIndex = 3
i = i + 1
Loop
End Sub
Display More