how to make cell pointer / cursor in special color?

[shah6084]

hi friends,

i find it's so difficult for me to update my daily report due to so many numbers in my worksheet. is there any way to create a special color (highlighting) on our cell pointer / cursor / indicator ?? Kindly answer me at my email address:

sshaari@hotmail.com

[Paul B]

This will change the background color of the ActiveCell to yellow anytime you select a new cell, either with the mouse or with the arrow keys.
Note : this procedure will remove any interior cell colors that you might have on your worksheet when the cells are selected, and will make undo useless, because it is running every time you change cells.

From http://www.cpearson.com/
Put in worksheet code

Private Sub Worksheet_SelectionChange(ByVal Target As Excel.Range)
Static OldRange As Range
On Error Resume Next
Target.Interior.ColorIndex = 6 ' yellow - change as needed
OldRange.Interior.ColorIndex = xlColorIndexNone
Set OldRange = Target
End Sub