cell hililte
 

Is there a program I can insert that will hilite the cell I am working in at
any time?

Thanks

Rus

You may want to try Chip Pearson's utility:
http://www.cpearson.com/excel/RowLiner.htm

Be aware that with this (and most macros), you lose the ability to do Edit|Undo.

D wrote:

Is there a program I can insert that will hilite the cell I am working in at
any time?

Thanks

Rus

--

Dave Peterson

Here is another, similar way

Private Sub Worksheet_SelectionChange(ByVal Target As Range)

Cells.FormatConditions.Delete
With Target.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
End With
.FormatConditions(1).Interior.ColorIndex = 20
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

"D" wrote in message
...
Is there a program I can insert that will hilite the cell I am working in
at
any time?

Thanks

Rus