how do I highlight the current row and column

[Ssalzman]

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

[dlw]

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

[Bob Phillips]

'----------------------------------------------------------------
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" <[email protected]> wrote in message
news:[email protected]...
> 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

[Ssalzman]

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" <[email protected]> wrote in message
> news:[email protected]...
> > 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
>
>
>

[Gord Dibben]

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
<[email protected]> 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

[evilCartman]

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

[shg]

Welcome to the forum, evilCartman. And congratulations on finding what you were looking for; that's why we insist on descriptive thread titles.

Now please take a few minutes to read the forum rules (link in menu bar) about posting questions in other peoples' thread, and then start your own.