[VBA]Sub dfghdfgh()
Dim i As Long
Dim area As Range
Dim j As Long

i = InputBox("Give the value of i")
Set area = Application.InputBox("Select range", "Range", , , , , , 8)

For j = 1 To area.Rows.Count Step i

area.Cells(j, 1).Interior.Color = RGB(200, 160, 35)
Next cell
End Sub
[/VBA]