Solved

MS Excel cell highlighting

Posted on 2013-06-24
7
310 Views
Last Modified: 2013-07-28
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
Comment
Question by:chima
7 Comments
 
LVL 12

Assisted Solution

by:duttcom
duttcom earned 100 total points
ID: 39273681
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
 
LVL 46

Accepted Solution

by:
Martin Liss earned 225 total points
ID: 39273697
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
 
LVL 4

Assisted Solution

by:Jorgen
Jorgen earned 175 total points
ID: 39273978
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
ScreenConnect 6.0 Free Trial

Check out the updates in one game-changing release, ScreenConnect 6.0, based on partner feedback. New features include a redesigned UI that improves session organization and overall user experience. See the enhancements for yourself!

 
LVL 46

Expert Comment

by:Martin Liss
ID: 39280128
Did any of the above help you?
0
 

Author Comment

by:chima
ID: 39302843
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
 

Author Closing Comment

by:chima
ID: 39362612
thank you for the wait.
0
 
LVL 46

Expert Comment

by:Martin Liss
ID: 39362624
You're welcome and I'm glad I was able to help.

Marty - MVP 2009 to 2013
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Microsoft Office Picture Manager was included in Office 2003, 2007, and 2010, but not in Office 2013. Users had hopes that it would be in Office 2016/Office 365, but it is not. Fortunately, the same zero-cost technique that works to install it with …
My experience with Windows 10 over a one year period and suggestions for smooth operation
Learn how to create and modify your own paragraph styles in Microsoft Word. This can be helpful when wanting to make consistently referenced styles throughout a document or template.
Many functions in Excel can make decisions. The most simple of these is the IF function: it returns a value depending on whether a condition you describe is true or false. Once you get the hang of using the IF function, you will find it easier to us…

825 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question