highlight only complete row currently being used.

[2MShad]

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

 

[Gord Dibben]

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

 

[L. Howard Kittle]

As Gord suggests, Chip's RowLiner really zeros you in on a secific cell,
along with the column and the row.

If you should only need to highlight a smaller portion of the row you could
use this little 'diddy to do so. It is adjustable to the width you may
want, what column to start and end highlighting. Other colors OUTSIDE the
designated area, Data, are safe.

Option Explicit

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Dim Data As Range
Dim i As Integer
Dim j As Integer
Dim k As Integer
Dim cells As Range
i = 2
j = 8
k = ActiveCell.Column()
Set Data = Range("B8:K22")

Data.Interior.ColorIndex = xlNone

If ActiveCell.Row < 8 Or ActiveCell.Row > 22 Or _
ActiveCell.Column < 2 Or ActiveCell.Column > 11 Then
Exit Sub
End If

ActiveCell.Offset(0, -(k - i)). _
Resize(1, 10).Interior.ColorIndex = 35 '26

End Sub

HTH
Regards,
Howard

 

[Shailesh Shah]

Besides you may try to use "workbook navigation" Excel addins from below
site. It has row highlight options with undo also works.

http://shahshaileshs.web.officelive.com/Addins.aspx


Regards,
Shailesh Shah
http://shahshaileshs.web.officelive.com/
If You Can't Excel with Talent, Triumph with Effort.

Free Addins Office Menu-2003 for Office-2007
http://shahshaileshs.web.officelive.com/MenuAddins.aspx

Free Exshail Classic Menu for Excel-2007
http://shahshaileshs.web.officelive.com/Exshail_Classic_Menu.aspx