vba to high Highlight row

[annadinesh]

Dear Sir,

i want to highlight row for selected Cell only from row 12


pls help

 

[mjf55]

Try this. Put this in the worksheet module for the sheet you want to use.

Private Sub Worksheet_SelectionChange(ByVal Target As Range)    If Target.Row = 12 Then
        Target.EntireRow.Interior.Color = vbYellow
    Else: Range("12:12").EntireRow.Interior.ColorIndex = xlNone
    End If
End Sub

 

[AkaTrouble]

also if you mean if the row is higher than 12 this code simply highlights the entire row rather than changing anything

Private Sub Worksheet_SelectionChange(ByVal Target As Range)

If ActiveCell.Row > 11 Then

Target.EntireRow.Select

End If


End Sub

 

[annadinesh]

Thanks a lot,

it works


thanks