highlight cursor row
 

A spreadsheet program (not sure which) I used to use would highlight the row
that the cursor was on when working in a spreadsheet. This helped in
scanning associated data in that row. Does Excel have this capability? I'm
not talking about changing the format of a row, just having it highlighted in
the view on screen as the cursor is moved from row to row.

highlight cursor row
 

Follow this link to Chip Pearson's page, where he has a Row Liner you
can download.

Hope this helps.

Pete

KUlibacct wrote:
A spreadsheet program (not sure which) I used to use would highlight the row
that the cursor was on when working in a spreadsheet. This helped in
scanning associated data in that row. Does Excel have this capability? I'm
not talking about changing the format of a row, just having it highlighted in
the view on screen as the cursor is moved from row to row.

highlight cursor row
 

Sorry,

I forgot the link:

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

Pete

Pete_UK wrote:
Follow this link to Chip Pearson's page, where he has a Row Liner you
can download.

Hope this helps.

Pete

KUlibacct wrote:
A spreadsheet program (not sure which) I used to use would highlight the row
that the cursor was on when working in a spreadsheet. This helped in
scanning associated data in that row. Does Excel have this capability? I'm
not talking about changing the format of a row, just having it highlighted in
the view on screen as the cursor is moved from row to row.

highlight cursor row
 

'----------------------------------------------------------------
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
'----------------------------------------------------------------
Cells.FormatConditions.Delete
With Target
With .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
.Interior.ColorIndex = 20
End With
End With
With .EntireColumn
.FormatConditions.Delete
.FormatConditions.Add Type:=xlExpression, Formula1:="TRUE"
With .FormatConditions(1)
With .Borders(xlLeft)
.LineStyle = xlContinuous
.Weight = xlThin
.ColorIndex = 5
End With
With .Borders(xlRight)
.LineStyle = xlContinuous
.Weight = xlThin
.ColorIndex = 5
End With
.Interior.ColorIndex = 20
End With
End With

.FormatConditions.Delete
.FormatConditions.Add Type:=xlExpression, Formula1:="TRUE"
.FormatConditions(1).Interior.ColorIndex = 36
End With

End Sub


'This is worksheet event code, which means that it needs to be
'placed in the appropriate worksheet code module, not a standard
'code module. To do this, right-click on the sheet tab, select
'the View Code option from the menu, and paste the code in.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"KUlibacct" wrote in message
...
A spreadsheet program (not sure which) I used to use would highlight the
row
that the cursor was on when working in a spreadsheet. This helped in
scanning associated data in that row. Does Excel have this capability?
I'm
not talking about changing the format of a row, just having it highlighted
in
the view on screen as the cursor is moved from row to row.

This is the excellent and complete code ever I have found.
I really appreciate Bob's work.

Cheers

The Row Liner program is awesome! It is very obvious where the cursor is, and this helps me with FIND results, which I use all the time! Thank you so much for the great tool!