Cell Colors as the cursor moves

[rrowe]

Is there a way to highlight ( in a color ) the cells as you move the cursor around in Excel? For instance, if you are in one cell, it would be in a color that you pick. When you move the cursor up, down, left, or right, the cell that you go to would then turn that color

 

[verluc]

Try the following code :

Sub Worksheet_SelectionChange(ByVal target As Range)
If Intersect(Range("A1:Z20"), Range(target(1).Address)) _
Is Nothing Then Exit Sub
Cells.Interior.ColorIndex = xlNone
ActiveCell.Interior.Color = vbCyan
End Sub

 

[rrowe]

Thanks for the quick reply. I don't know how to enter the code. Can you walk me thru, thanks!

 

[Peter_SSs]

don't know how to enter the code. Can you walk me thru, thanks!

1. Right click the sheet name tab and choose "View Code".
2. Paste the code in the main right hand pane of the Visual Basic window that opens in step 1.
3. Close the VB window.

Notes:
1. The code is just to colour the cell if it is in the range A1:Z20, though you can change that if you want.
2. Be aware that if you have any cells in your worksheet coloured manually, that colour will be deleted by this code.

 

[rrowe]

Thanks Verluc. It's great to have folks like you to be on standby for us rookies. Have a great day!!