highlight row/column to track current cell ... and more!
 

I'm wondering ... is there a way for Excel to highlight the row and column
of the current cell?

This would make it easier to associate the current cell to its row and
column ... which often contain info related to the current cell.

I located the info at this link but these solutions are destructive to the
formatting of the rows/columns ... which is unacceptable ...
http://www.mrexcel.com/archive/VBA/26758.html

On widescreen LCD displays with high resolution, its very likely that Excel
users will have many many rows and columns ... and this current cell
tracking/highlighting idea would be very handy.

Frankly, I'm kind of surprised this wasn't already anticipated by Microsoft
.... hmmm.

It could be as simple as using an alternate color to draw the default cell
borders of the row and column of the current cell.

Thoughts anyone??

Phil

highlight row/column to track current cell ... and more!
 

How about row only. Put in sheet module

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Dim MyRng As Range
Set MyRng = Target.EntireRow
Application.EnableEvents = False
On Error GoTo end1
Application.Cells.FormatConditions.Delete
With MyRng
.FormatConditions.Add Type:=xlExpression, Formula1:= _
"=ROW()=ROW(INDIRECT(CELL(""address"")))"
With .FormatConditions(1).Font
.Bold = True
.Italic = False
.ColorIndex = 1
End With
.FormatConditions(1).Interior.ColorIndex = 36
End With



end1:
Application.EnableEvents = True
End Sub


--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"prupp" wrote in message
...
I'm wondering ... is there a way for Excel to highlight the row and column
of the current cell?

This would make it easier to associate the current cell to its row and
column ... which often contain info related to the current cell.

I located the info at this link but these solutions are destructive to the
formatting of the rows/columns ... which is unacceptable ...
http://www.mrexcel.com/archive/VBA/26758.html

On widescreen LCD displays with high resolution, its very likely that
Excel users will have many many rows and columns ... and this current cell
tracking/highlighting idea would be very handy.

Frankly, I'm kind of surprised this wasn't already anticipated by
Microsoft ... hmmm.

It could be as simple as using an alternate color to draw the default cell
borders of the row and column of the current cell.

Thoughts anyone??

Phil

highlight row/column to track current cell ... and more!
 

Yeh ... that works good ... it will certainly help.

Can this be done with columns alone as well?

"Don Guillett" wrote in message
...
How about row only. Put in sheet module

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Dim MyRng As Range
Set MyRng = Target.EntireRow
Application.EnableEvents = False
On Error GoTo end1
Application.Cells.FormatConditions.Delete
With MyRng
.FormatConditions.Add Type:=xlExpression, Formula1:= _
"=ROW()=ROW(INDIRECT(CELL(""address"")))"
With .FormatConditions(1).Font
.Bold = True
.Italic = False
.ColorIndex = 1
End With
.FormatConditions(1).Interior.ColorIndex = 36
End With



end1:
Application.EnableEvents = True
End Sub


--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"prupp" wrote in message
...
I'm wondering ... is there a way for Excel to highlight the row and
column of the current cell?

This would make it easier to associate the current cell to its row and
column ... which often contain info related to the current cell.

I located the info at this link but these solutions are destructive to
the formatting of the rows/columns ... which is unacceptable ...
http://www.mrexcel.com/archive/VBA/26758.html

On widescreen LCD displays with high resolution, its very likely that
Excel users will have many many rows and columns ... and this current
cell tracking/highlighting idea would be very handy.

Frankly, I'm kind of surprised this wasn't already anticipated by
Microsoft ... hmmm.

It could be as simple as using an alternate color to draw the default
cell borders of the row and column of the current cell.

Thoughts anyone??

Phil

highlight row/column to track current cell ... and more!
 

Non-destructive row/column outlining can be found in Chip Pearson's ROWLINER
add-in.

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


Gord Dibben MS Excel MVP


On Mon, 11 Feb 2008 13:40:49 -0500, "prupp" wrote:

Yeh ... that works good ... it will certainly help.

Can this be done with columns alone as well?

"Don Guillett" wrote in message
...
How about row only. Put in sheet module

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Dim MyRng As Range
Set MyRng = Target.EntireRow
Application.EnableEvents = False
On Error GoTo end1
Application.Cells.FormatConditions.Delete
With MyRng
.FormatConditions.Add Type:=xlExpression, Formula1:= _
"=ROW()=ROW(INDIRECT(CELL(""address"")))"
With .FormatConditions(1).Font
.Bold = True
.Italic = False
.ColorIndex = 1
End With
.FormatConditions(1).Interior.ColorIndex = 36
End With



end1:
Application.EnableEvents = True
End Sub


--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"prupp" wrote in message
...
I'm wondering ... is there a way for Excel to highlight the row and
column of the current cell?

This would make it easier to associate the current cell to its row and
column ... which often contain info related to the current cell.

I located the info at this link but these solutions are destructive to
the formatting of the rows/columns ... which is unacceptable ...
http://www.mrexcel.com/archive/VBA/26758.html

On widescreen LCD displays with high resolution, its very likely that
Excel users will have many many rows and columns ... and this current
cell tracking/highlighting idea would be very handy.

Frankly, I'm kind of surprised this wasn't already anticipated by
Microsoft ... hmmm.

It could be as simple as using an alternate color to draw the default
cell borders of the row and column of the current cell.

Thoughts anyone??

Phil