Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Excel Navigation
Hello all,
Like most of you, I use excel a LOT. Is there a way to highlight the row and column as I am navigating from one cell to another? Cheers, John |
#2
|
|||
|
|||
John,
Here is one way Private Sub Worksheet_SelectionChange(ByVal Target As Range) Cells.FormatConditions.Delete With Target.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 End With .FormatConditions(1).Interior.ColorIndex = 20 End With Target.FormatConditions.Delete With Target.EntireColumn .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 End With .FormatConditions(1).Interior.ColorIndex = 20 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 RP (remove nothere from the email address if mailing direct) "spartanmba" wrote in message ... Hello all, Like most of you, I use excel a LOT. Is there a way to highlight the row and column as I am navigating from one cell to another? Cheers, John |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
Difference in number of Excel NewsGroups | Excel Discussion (Misc queries) | |||
Excel worksheet tabs navigation | Excel Worksheet Functions | |||
How do I configure navigation in Excel? In particular, the ctrl +. | Setting up and Configuration of Excel | |||
Excel 2003 navigation | Setting up and Configuration of Excel |