Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

MS Excel cell highlighting

Posted on 2013-06-24
7
Medium Priority
?
344 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
7 Comments
 
LVL 12

Assisted Solution

by:duttcom
duttcom earned 400 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 49

Accepted Solution

by:
Martin Liss earned 900 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 700 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
Nothing ever in the clear!

This technical paper will help you implement VMware’s VM encryption as well as implement Veeam encryption which together will achieve the nothing ever in the clear goal. If a bad guy steals VMs, backups or traffic they get nothing.

 
LVL 49

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 49

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

How to Use the Help Bell

Need to boost the visibility of your question for solutions? Use the Experts Exchange Help Bell to confirm priority levels and contact subject-matter experts for question attention.  Check out this how-to article for more information.

Question has a verified solution.

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

How to get Spreadsheet Compare 2016 working with the 64 bit version of Office 2016
Ever wonder what it's like to get hit by ransomware? "Tom" gives you all the dirty details first-hand – and conveys the hard lessons his company learned in the aftermath.
This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

618 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