View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
evgny[_2_] evgny[_2_] is offline
external usenet poster
 
Posts: 28
Default Cell fill color. Row to match specific cell.

hi CADinDallas

Try this
Sub Makro1()

Dim colE As Double
Dim i As Double
colE = Cells(Rows.Count, "E").End(xlUp).Row
For i = 1 To colE
If Range("E" & i) = "c" Then
Range("A" & i & ":G" & i).Interior.ColorIndex = 6
End If
Next i
end sub

Regards Yngve