• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 345
  • Last Modified:

MS Excel cell highlighting

Hello,
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.
0
chima
Asked:
chima
3 Solutions
 
duttcomCommented:
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.
0
 
Martin LissRetired ProgrammerCommented:
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

0
 
JorgenCommented:
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

regards

Jørgen
Krydsmarkering-af-aktiv-celle.xlsm
0
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

 
Martin LissRetired ProgrammerCommented:
Did any of the above help you?
0
 
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.
0
 
chimaAuthor Commented:
thank you for the wait.
0
 
Martin LissRetired ProgrammerCommented:
You're welcome and I'm glad I was able to help.

Marty - MVP 2009 to 2013
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now