Row color change
 

I need to insert some code so that when I click on a cell the fill color for
the entire row changes to yellow.

Example:

If I click on C3 then Row 3 starting from A3:IV3 would change the row's
color to yellow.

Thanks
Bill

Row color change
 

put this macro into the worksheet object

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
y = Trim(Str(Target.Row))
Rows(y).Interior.ColorIndex = 6
End Sub


"Bill" wrote:

I need to insert some code so that when I click on a cell the fill color for
the entire row changes to yellow.

Example:

If I click on C3 then Row 3 starting from A3:IV3 would change the row's
color to yellow.

Thanks
Bill