software

I would like to be able to view my position easier, and when I am in a column
and row to the far right, having the row and column number highlighted isnt
sufficient. Is there anyway to have the current row and column highlighted
with color?
Thanks

Nothing you can do but upgrade to a newer version of Excel, they use a
different color/shading.

quot;Ssalzmanquot; wrote:

gt; I would like to be able to view my position easier, and when I am in a column
gt; and row to the far right, having the row and column number highlighted isnt
gt; sufficient. Is there anyway to have the current row and column highlighted
gt; with color?
gt; Thanks


'----------------------------------------------------------------
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
'----------------------------------------------------------------
Cells.FormatConditions.Delete
With Target
With .EntireRow
.FormatConditions.Add Type:=xlExpression, Formula1:=quot;TRUEquot;
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:=quot;TRUEquot;
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:=quot;TRUEquot;
.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

(remove nothere from email address if mailing direct)

quot;Ssalzmanquot; gt; wrote in message
...
gt; I would like to be able to view my position easier, and when I am in a
column
gt; and row to the far right, having the row and column number highlighted
isnt
gt; sufficient. Is there anyway to have the current row and column
highlighted
gt; with color?
gt; Thanks
Thank you, I will try this.

quot;Bob Phillipsquot; wrote:

gt;
gt; '----------------------------------------------------------------
gt; Private Sub Worksheet_SelectionChange(ByVal Target As Range)
gt; '----------------------------------------------------------------
gt; Cells.FormatConditions.Delete
gt; With Target
gt; With .EntireRow
gt; .FormatConditions.Add Type:=xlExpression, Formula1:=quot;TRUEquot;
gt; With .FormatConditions(1)
gt; With .Borders(xlTop)
gt; .LineStyle = xlContinuous
gt; .Weight = xlThin
gt; .ColorIndex = 5
gt; End With
gt; With .Borders(xlBottom)
gt; .LineStyle = xlContinuous
gt; .Weight = xlThin
gt; .ColorIndex = 5
gt; End With
gt; .Interior.ColorIndex = 20
gt; End With
gt; End With
gt; With .EntireColumn
gt; .FormatConditions.Delete
gt; .FormatConditions.Add Type:=xlExpression, Formula1:=quot;TRUEquot;
gt; With .FormatConditions(1)
gt; With .Borders(xlLeft)
gt; .LineStyle = xlContinuous
gt; .Weight = xlThin
gt; .ColorIndex = 5
gt; End With
gt; With .Borders(xlRight)
gt; .LineStyle = xlContinuous
gt; .Weight = xlThin
gt; .ColorIndex = 5
gt; End With
gt; .Interior.ColorIndex = 20
gt; End With
gt; End With
gt;
gt; .FormatConditions.Delete
gt; .FormatConditions.Add Type:=xlExpression, Formula1:=quot;TRUEquot;
gt; .FormatConditions(1).Interior.ColorIndex = 36
gt; End With
gt;
gt; End Sub
gt;
gt;
gt; 'This is worksheet event code, which means that it needs to be
gt; 'placed in the appropriate worksheet code module, not a standard
gt; 'code module. To do this, right-click on the sheet tab, select
gt; 'the View Code option from the menu, and paste the code in.
gt;
gt; --
gt; HTH
gt;
gt; Bob Phillips
gt;
gt; (remove nothere from email address if mailing direct)
gt;
gt; quot;Ssalzmanquot; gt; wrote in message
gt; ...
gt; gt; I would like to be able to view my position easier, and when I am in a
gt; column
gt; gt; and row to the far right, having the row and column number highlighted
gt; isnt
gt; gt; sufficient. Is there anyway to have the current row and column
gt; highlighted
gt; gt; with color?
gt; gt; Thanks
gt;
gt;
gt;

You could try Chip Pearson's ROWLINER add-in.

www.cpearson.com/excel/RowLiner.htmGord Dibben MS Excel MVP

On Thu, 30 Mar 2006 07:06:02 -0800, Ssalzman
gt; wrote:

gt;I would like to be able to view my position easier, and when I am in a column
gt;and row to the far right, having the row and column number highlighted isnt
gt;sufficient. Is there anyway to have the current row and column highlighted
gt;with color?
gt;Thanks