Color Indicator

[Bob]

Is there a means of changing the color of box indicator in
which the cell you move to is diferent. Another words
everytime you move to another cell the cursor which is a
standard black outlined can be changed. Thanks for your
help, hope this was a descriptive enough question.

 

[Dave Peterson]

Chip Pearson has an addin that will do what you want (and more):
http://www.cpearson.com/excel/RowLiner.htm

The biggest drawback is that like most macros, this disables the Undo feature.

 

[JMay]

If you mean you want the activecell to constantly be say "Yellow", then
paste the following into the module named Thisworkbook:

Sub Workbook_SheetSelectionChange(ByVal Sh As Object, _
ByVal Target As Excel.Range)
On Error Resume Next
Sh.Cells.Interior.ColorIndex = xlColorIndexNone
Target.Interior.ColorIndex = 6 ' yellow - change as needed
End Sub