Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 01-19-2022, 12:10 PM
Jimbir's Avatar
Jimbir Jimbir is offline Seleted Cell Highlighting Windows 7 64bit Seleted Cell Highlighting Office 2007
Advanced Beginner
Seleted Cell Highlighting
 
Join Date: Nov 2010
Posts: 33
Jimbir is on a distinguished road
Default Seleted Cell Highlighting


When I selected a cell in my 2007 version of Excel, the background would highlight with a very light gray color. In the 2019 version of Excel there is only a slight change in the border around the cell to indicate that it is selected and it is very difficult to find that cell in a large spreadsheet. Is there a setting I can use to change the properties of a selected cell?


Jim B.
Reply With Quote
  #2  
Old 01-19-2022, 04:34 PM
Logit Logit is offline Seleted Cell Highlighting Windows 10 Seleted Cell Highlighting Office 2007
Expert
 
Join Date: Jan 2017
Posts: 434
Logit will become famous soon enoughLogit will become famous soon enough
Default

Interesting. My 2007 version just places a thick border around the cell.

???
Reply With Quote
  #3  
Old 01-22-2022, 07:33 AM
Jimbir's Avatar
Jimbir Jimbir is offline Seleted Cell Highlighting Windows 7 64bit Seleted Cell Highlighting Office 2007
Advanced Beginner
Seleted Cell Highlighting
 
Join Date: Nov 2010
Posts: 33
Jimbir is on a distinguished road
Default

That may have been what was happening in my 2007 Excel. I had display problems with my 2007 version of office so I uninstalled it and installed the 2019 version. Neither this version of Excel or Word will put a border around the selected cell/cells. Is there a setting which I can use that will make this happen?

Jim B.
Reply With Quote
  #4  
Old 01-22-2022, 09:04 AM
Logit Logit is offline Seleted Cell Highlighting Windows 10 Seleted Cell Highlighting Office 2007
Expert
 
Join Date: Jan 2017
Posts: 434
Logit will become famous soon enoughLogit will become famous soon enough
Default

I don't know of any setting ... although there may be one. I've always understood it was an editable design of Excel.
Reply With Quote
  #5  
Old 01-24-2022, 06:19 AM
wiganken wiganken is offline Seleted Cell Highlighting Windows 10 Seleted Cell Highlighting Office 2019
Competent Performer
 
Join Date: Jul 2018
Posts: 248
wiganken will become famous soon enough
Default

I have 2019 version and Excel cells look like photo on my machine. Ignoring the pale green background (because that is my customised colour) does your cell highlighting look similar? Maybe post a photo?
Attached Images
File Type: png Excel Cell.png (15.4 KB, 12 views)
Reply With Quote
  #6  
Old 01-24-2022, 06:27 AM
wiganken wiganken is offline Seleted Cell Highlighting Windows 10 Seleted Cell Highlighting Office 2019
Competent Performer
 
Join Date: Jul 2018
Posts: 248
wiganken will become famous soon enough
Default

This might help but it is not simple: -

How to highlight active cell or selection in Excel?
Reply With Quote
  #7  
Old 01-24-2022, 06:31 AM
Jimbir's Avatar
Jimbir Jimbir is offline Seleted Cell Highlighting Windows 7 64bit Seleted Cell Highlighting Office 2007
Advanced Beginner
Seleted Cell Highlighting
 
Join Date: Nov 2010
Posts: 33
Jimbir is on a distinguished road
Default

That's what my cells look like. Now put a border around a couple of cells and then select one of them. You'll see what I'm talking about.


Jim
Reply With Quote
  #8  
Old 01-24-2022, 07:36 AM
Logit Logit is offline Seleted Cell Highlighting Windows 10 Seleted Cell Highlighting Office 2007
Expert
 
Join Date: Jan 2017
Posts: 434
Logit will become famous soon enoughLogit will become famous soon enough
Default

Image Attached .
Attached Images
File Type: jpg Cell Highlight.jpg (68.1 KB, 13 views)
Reply With Quote
  #9  
Old 01-24-2022, 08:45 AM
Jimbir's Avatar
Jimbir Jimbir is offline Seleted Cell Highlighting Windows 7 64bit Seleted Cell Highlighting Office 2007
Advanced Beginner
Seleted Cell Highlighting
 
Join Date: Nov 2010
Posts: 33
Jimbir is on a distinguished road
Default

Quote:
Originally Posted by wiganken View Post
This might help but it is not simple: -

How to highlight active cell or selection in Excel?



Just what I was looking for bur, it only works in a xlsm file. How would I open a new workbook as a xlsm?
Reply With Quote
  #10  
Old 01-24-2022, 09:11 AM
wiganken wiganken is offline Seleted Cell Highlighting Windows 10 Seleted Cell Highlighting Office 2019
Competent Performer
 
Join Date: Jul 2018
Posts: 248
wiganken will become famous soon enough
Default

I didn't study the article. It just sounded as if it is what you need. The instructions begin with the text "The following VBA code...." then steps 1,2, 3 and 'Notes'.

There may be something more simple on tinternet but that was the first thing I found.

Good luck.
Reply With Quote
  #11  
Old 01-24-2022, 09:43 AM
Jimbir's Avatar
Jimbir Jimbir is offline Seleted Cell Highlighting Windows 7 64bit Seleted Cell Highlighting Office 2007
Advanced Beginner
Seleted Cell Highlighting
 
Join Date: Nov 2010
Posts: 33
Jimbir is on a distinguished road
Default

Thanks for your help. When you get to step 3, it just says "save". When you try to save it in a xlxs file, you get an error saying It can only be saved in a macro enabled file (xlsm) I'd like to be able to open a new workbook in that format. The only way I know how to do that is, open a new book then immediately save it as a xlsm file.
Reply With Quote
  #12  
Old 01-25-2022, 02:51 AM
wiganken wiganken is offline Seleted Cell Highlighting Windows 10 Seleted Cell Highlighting Office 2019
Competent Performer
 
Join Date: Jul 2018
Posts: 248
wiganken will become famous soon enough
Default

Is the following any use? I haven't watched the video but it sounds as if it may be useful: -

Highlight Active Cell in Excel (Excel Magic Trick # 1) - YouTube
Reply With Quote
  #13  
Old 01-25-2022, 06:09 AM
Jimbir's Avatar
Jimbir Jimbir is offline Seleted Cell Highlighting Windows 7 64bit Seleted Cell Highlighting Office 2007
Advanced Beginner
Seleted Cell Highlighting
 
Join Date: Nov 2010
Posts: 33
Jimbir is on a distinguished road
Default

Quote:
Originally Posted by wiganken View Post
Is the following any use? I haven't watched the video but it sounds as if it may be useful: -

Highlight Active Cell in Excel (Excel Magic Trick # 1) - YouTube

Thanks, but...This wasn't helpful.
Reply With Quote
  #14  
Old 01-25-2022, 06:12 AM
Jimbir's Avatar
Jimbir Jimbir is offline Seleted Cell Highlighting Windows 7 64bit Seleted Cell Highlighting Office 2007
Advanced Beginner
Seleted Cell Highlighting
 
Join Date: Nov 2010
Posts: 33
Jimbir is on a distinguished road
Default

Quote:
Originally Posted by wiganken View Post
This might help but it is not simple: -

How to highlight active cell or selection in Excel?

I have this code embedded in a workbook. How do I view it when I'm in the book?
Reply With Quote
  #15  
Old 01-25-2022, 07:10 AM
wiganken wiganken is offline Seleted Cell Highlighting Windows 10 Seleted Cell Highlighting Office 2019
Competent Performer
 
Join Date: Jul 2018
Posts: 248
wiganken will become famous soon enough
Default

I'm out of ideas so I hope you find help elsewhere.

Maybe it is not possible unless you into advanced computer stuff?
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Conditional Highlighting When Approaching End of Quarter if Date in Cell is From Previous Quarter PrincessApril Excel 6 12-06-2019 02:38 PM
Seleted Cell Highlighting Clear all cell colors within a range starting at cell A8 and change row of active cell to yellow FUGMAN Excel Programming 7 02-05-2017 08:37 AM
Word tables: prevent word from highlighting whole cell when I highlight text skylark53 Word 2 08-04-2015 08:12 AM
Seleted Cell Highlighting highlighting Donnathompson Word 4 08-07-2011 05:21 PM
Cell highlighting Issue jasonk916 Excel 0 12-07-2009 07:05 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 02:26 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2022, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2022 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft