There are methods using sheetchange events but the easiest method is to use
Chip Pearson's RowLiner add-in.

http://www.cpearson.com/excel/RowLiner.htm

Just a note...........Rowliner won't work on protected sheets.

If your sheet is protected you need event code.


Gord Dibben MS Excel MVP

On Thu, 15 Apr 2010 13:25:01 -0700, 2MShad
wrote:

Is there a setting that will highlight a complete row if your cursor is in
that row. I know the row number will be highlighted. Thanks