highlight active row

[tratra]

hi guys

I have a problem.
I already used the conditional format to highlight my duplicate columns.
And now, i need to highlight the active rows .
Can someone teach me the code? thanks

 

[Joe4]

Chip Pearson wrote some code to highlight the ActiveCell, here:
http://www.cpearson.com/excel/excelM.htm#HighlightActiveCell

With a simple modification, we can make it highlight the whole Row instead of just the cell, like this:

Private Sub Workbook_SheetSelectionChange(ByVal Sh As Object, ByVal Target As Range)

Static OldRange As Range
On Error Resume Next
Target.EntireRow.Interior.ColorIndex = 6 ' yellow - change as needed
OldRange.EntireRow.Interior.ColorIndex = xlColorIndexNone
Set OldRange = Target

End Sub