Is there a way to change the accentuation of the row and column highlights in Excel 2016?

I would like to change the colour of the highlights of the row, column and cell in Excel to be red instead of just grey. As when doing a search it is sometimes difficult to find the selected cell quickly. See attached.
ExcelCapture.JPG
Gavin PittManaging DirectorAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Shaun KlineLead Software EngineerCommented:
In Excel 2016,  Options -> Advanced -> "Display options for this worksheet:" -> Gridline coloor
0
Gavin PittManaging DirectorAuthor Commented:
Nope that is not what I am looking for.
0
Rob HensonFinance AnalystCommented:
It is possible to add conditional formatting that highlights the whole row and column of the active cell.

I have done this before, let me see if I can find a sample.
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

Rob HensonFinance AnalystCommented:
Highlight the sheet's used area and apply conditional formatting with these two rules

Highlight row:          =ROW(A1)=CELL("row")
Highlight column:   =COLUMN(A1)=CELL("col")

When applying each rule, choose the fill format to highlight. The formatting will only change on calculation, press F9 to get the change.
0
Rob HensonFinance AnalystCommented:
Actually can do with one rule:

=OR(ROW(A1)=CELL("row"),COLUMN(A1)=CELL("col"))

Thanks
0
Gavin PittManaging DirectorAuthor Commented:
I actually want the column and row highlighted in red and then possibly the usual selected cell which is a black rectangle to be red as well. Am I making sense?
0
Rob HensonFinance AnalystCommented:
See attached

Move the cursor then Press F9 to recalculate and the highlight will shift.

There's almost no point having the cell border change as the cell selector outline will hide it.
Active-cell-highlight.xlsx
0
Gavin PittManaging DirectorAuthor Commented:
That is very smart but does not solve my problem. Thanks
0
AlanConsultantCommented:
Hi Bit247,

Not sure if it is possible to do exactly what you are asking for.

If John's solution does not work for you as is, maybe this version will (see attached).  It does not require you to press F9 to change the highlighting on the row and column.

Would that be close enough?

Alan.
EE-29066715-Active-cell-highlight-V.xlsm
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Gavin PittManaging DirectorAuthor Commented:
That is pretty good. How do I go about making this change easily to any Excel file that I receive?
0
AlanConsultantCommented:
Hi Bit247,

You would add the conditional formatting that John outlined above (and is in the file I attached) to any worksheet that you want it in.

You would also add the Worksheet_SelectionChange event to the worksheet and just put in there 'Calculate'.  You can see that in the file I posted if you open the VB Editor (Alt-F11) and click on Sheet1 - you should see the code module.

Another option for new files, would be to create a template file with that all in the default worksheets (or three if you start with three).  Then any new worksheet you want, you just take a blank worksheet and create a copy of it.

You could also take the file I posted above, and make that your template.


Alan.
0
Gavin PittManaging DirectorAuthor Commented:
Ok thanks
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.

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.