right click sheet tab>view code>insert this>save
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
  Cells.Interior.ColorIndex = xlColorIndexNone
  Target.EntireRow.Interior.ColorIndex = 36
End Sub

You should see the row number and column letter highlighted,
but if you want to hightlight the row and column itself you can use
a macro,  or a bit less of a problem if you already have shading
on cells would be to highlight the borders  see Chip Pearson's
   Row liner  (addin)
   http://www.cpearson.com/excel/RowLiner.htm
as with any macro solution you lose the ability to use  Undo  (Ctrl+Z)  so
that is a very big trade off.
---
HTH,
David McRitchie, Microsoft MVP - Excel    [site changed  Nov. 2001]
My Excel Pages:  http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page:        http://www.mvps.org/dmcritchie/excel/search.htm