how do I highlight the current row and column

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.

"Ssalzman" wrote:

> 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

'----------------------------------------------------------------
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

(remove nothere from email address if mailing direct)

"Ssalzman" <Ssalzman@discussions.microsoft.com> wrote in message
news:627F8EDD-A1EB-4EA0-8A7B-6B5A39C944A6@microsoft.com...
> 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

Thank you, I will try this.

"Bob Phillips" wrote:

>
> '----------------------------------------------------------------
> 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
>
> (remove nothere from email address if mailing direct)
>
> "Ssalzman" <Ssalzman@discussions.microsoft.com> wrote in message
> news:627F8EDD-A1EB-4EA0-8A7B-6B5A39C944A6@microsoft.com...
> > 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
>
>
>

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

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


Gord Dibben MS Excel MVP

On Thu, 30 Mar 2006 07:06:02 -0800, Ssalzman
<Ssalzman@discussions.microsoft.com> wrote:

>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

Thanks This is exactly what I was searching for
There is only one problem I have with it and that is that when I copy (CTRL+C) and then I change cells and appears to clear the clipboard and I can't paste it. Is that something I will just have to live with or does anyone nay thoughts for fixing that.
I am not experienced at all with VBA.

Thanks in advance