MS Excel cell highlighting

I searched the Excel options setting and searched the help menu, but could not find my answer.
My question is; is there a way to make the cell highlight to a color when stepping into the cell, let's say when striking the "arrow key?"

When I strike the down arrow key the next cell down gets selected and I see a faint boarder around that cell.  I need for that cell to clearly become identifiable with another color or such.
This could happen if the boarder changes color.
Who is Participating?
Martin LissConnect With a Mentor Older than dirtCommented:
Consider this a "proof of concept". I'm using colors rather than borders but you can change that.

Option Explicit
Dim OldCellAddress As String

Private Sub Workbook_SheetSelectionChange(ByVal Sh As Object, ByVal Target As Range)
On Error Resume Next

Range(OldCellAddress).Interior.Color = vbWhite
Cells(Target.Row, Target.Column).Interior.Color = vbRed
OldCellAddress = Target.Address

End Sub

Open in new window

duttcomConnect With a Mentor Commented:
You can change the colour scheme for Excel; go to File -> Options and then in the General area, the third option is Color Scheme -> Blue, Silver or Black.

Blue is the default, but one of the other options might make the border a bit clearer for you.
JorgenConnect With a Mentor Commented:
Hi Chima,

Have a look on this file, that gives a cross that specificly shows where you are. It shows very clearly also your row and your column, and it is possible to modify


The new generation of project management tools

With’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

Martin LissOlder than dirtCommented:
Did any of the above help you?
chimaAuthor Commented:
Jorgen and everyone, sorry for the delay.  Jorgen, yes like that, but I am hoping that when I move the focus (move the mouse and click on another app) that the Excel sheet would continue to highlight the cell I had clicked on.
chimaAuthor Commented:
thank you for the wait.
Martin LissOlder than dirtCommented:
You're welcome and I'm glad I was able to help.

Marty - MVP 2009 to 2013
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.