Highlight row ?

[Zabi]

Anyone know if this is possible with excel ?

Example: Excel "cursor" is now at B3, it should highlight row 3 (ie.
with different color). When i press "arrow down" cursor is on B4 and
excel should automatically highlight row 3 etc. etc.

Will be very grateful if someone can help me!

-Jari

 

[Zabi]

Typo

excel should automatically highlight row 3 etc. etc.

excel should automatically highlight row 4 !!!

 

[Don Guillett]

right click sheet tab>view code>insert this

'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

 

[Gord Dibben]

Suggest you try Chip Pearson's Rowliner add-in.

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


Gord Dibben MS Excel MVP

 

[jari.lindgren]

Gord Dibben kirjoitti:

Suggest you try Chip Pearson's Rowliner add-in.

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


Gord Dibben MS Excel MVP

Thank you !!
This is just what i needed!

-Jari