Highlight Row when selected
 

hi is it possible to highlight a row when you select a cell on a row.

For example I select B28, the row B becomes highlighted, then when i
click on B29 that one becomes highlighted and B28 becomes
un-highlighted.

The only cells on each row i wont highlighting is B:I.

Thanks :)


--
cassy01
------------------------------------------------------------------------
cassy01's Profile: http://www.excelforum.com/member.php...nfo&userid=780
View this thread: http://www.excelforum.com/showthread...hreadid=422013

Good morning (again) Cassy01

Chip Pearson provides an add in that will highlight the rows as you are
working. If you want this you can download it from he

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

HTH

DominicB


--
dominicb
------------------------------------------------------------------------
dominicb's Profile: http://www.excelforum.com/member.php...o&userid=18932
View this thread: http://www.excelforum.com/showthread...hreadid=422013

right click sheet tabview codeinsert thisSAVE

'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

"cassy01" wrote in
message ...

hi is it possible to highlight a row when you select a cell on a row.

For example I select B28, the row B becomes highlighted, then when i
click on B29 that one becomes highlighted and B28 becomes
un-highlighted.

The only cells on each row i wont highlighting is B:I.

Thanks :)


--
cassy01
------------------------------------------------------------------------
cassy01's Profile:
http://www.excelforum.com/member.php...nfo&userid=780
View this thread: http://www.excelforum.com/showthread...hreadid=422013