Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#5
|
|||
|
|||
This is the excellent and complete code ever I have found.
I really appreciate Bob's work. Cheers Quote:
|
#6
|
|||
|
|||
Quote:
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Highlight the entire row or particular cell using conditional formatting | New Users to Excel | |||
Possible to highlight cells depending on value from vlook up? | Excel Discussion (Misc queries) | |||
Highlight a row automatically if a cell meets certain criteria | Excel Worksheet Functions | |||
Highlight all colums in Bar Graph | Charts and Charting in Excel | |||
How can I highlight every other group of data? | Excel Discussion (Misc queries) |