Highlighting the selected row or column

Is there a way to put the cursor in a cell and have that entire row and/or
column highlighted? I would like the highlighting to be temporary and move
with the selected cell.

Thank you in advance.

Lewis, have a look at Chip's addin at
http://www.cpearson.com/excel/rowliner.htm

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"Lewis Clark" <lewis_clark_644 @ yahoo.com> wrote in message
news:HwLce.637$nN.574@trnddc05...
> Is there a way to put the cursor in a cell and have that entire row and/or
> column highlighted? I would like the highlighting to be temporary and
move
> with the selected cell.
>
> Thank you in advance.
>
>

right click sheet tab>view code>insert this>SAVE

'McCurdy.Here is something inspired by Don Guillett.
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
SalesAid Software
donaldb@281.com
"Lewis Clark" <lewis_clark_644 @ yahoo.com> wrote in message
news:HwLce.637$nN.574@trnddc05...
> Is there a way to put the cursor in a cell and have that entire row and/or
> column highlighted? I would like the highlighting to be temporary and
move
> with the selected cell.
>
> Thank you in advance.
>
>

Thank you Paul and Don. Works great!

Lewis

glad to help

--
Don Guillett
SalesAid Software
donaldb@281.com
"Lewis Clark" <lewis_clark_644 @ yahoo.com> wrote in message
news:Vqgde.3300$nN.897@trnddc05...
> Thank you Paul and Don. Works great!
>
> Lewis
>
>