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