Here's one by Bob Phillips. Right click sheet tabview codeinsert this.

Private Sub Worksheet_SelectionChange(ByVal Target As Range)

Cells.FormatConditions.Delete
With Target.EntireRow
.FormatConditions.Add Type:=xlExpression, Formula1:="TRUE"
With .FormatConditions(1)
With .Borders(xlTop)
.LineStyle = xlContinuous
.Weight = xlThin
.ColorIndex = 5
End With
With .Borders(xlBottom)
.LineStyle = xlContinuous
.Weight = xlThin
.ColorIndex = 5
End With
End With
.FormatConditions(1).Interior.ColorIndex = 20
End With

End Sub


--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"pswanie" wrote in message
...




Hi all

i got a sheet where the user use only column m down. but i want the row
of
the active cell to be hightlight.

in other words if a user select m12 i want the row m12 to be highlighted
automatic. The reason for this is that they need to easily see that they
are in the row with the right product in colum b down



Column b down will have the product name and in m they need to enter
amount
of product to order. i cant hide the other columns as there are info in
that help them make the order....

regards


Phillip
--
Helpful advice on posting to newsgroups here...
http://www.cpearson.com/excel/newposte.htm