Change the find highlight color in Excel 2007?

RSS

Amazingly, there's no real provision for changing the highlight color of the Ctrl-F search results in Excel 2007. I have a spreadsheet from an associate that has a background color that is the same as the search results color. Some folks have found that tweaking "display" colors deep in Windows settings has an effect - but it tends to be temoporary. A better solution is to change the way one searches. Instead of using "Find next" after entering your search phrase, first click "Find all" and then click "Find next." This will put a thick black surround around the search results, and you'll be able to see them.


Written by Lamar Stonecypher (20,035 pts ) in Windows Platform Blog
Last Edited on Feb 24 2009, 02:15 PM

Comments

Sep 29, 2009 9:02 PM
Andy
Thank you...
Thank you so much for your finding. I really hate office 2007, but had no choice since I couldn't get office 2003 anymore these days. I have been streesed out with the way excel handle search result since you can't see anything at all. Again, thank you for your post.
Aug 10, 2009 12:02 PM
sharon
Thank-you Too
Every couple of days, I would google this problem with different search words. FINALLY used the magic words to find your solutions. I too felt the need to say thanks.
Jun 22, 2009 9:08 AM
Kevin
Thank-you
Lamar, I gotta tell you that I've looked for a solution to this very problem on and off for a while. Has really driven me crazy at times. After reading your article, I felt the need to say thanks.
 

Sign Up for Weekly Updates
Enter your email to subscribe to the Windows Newsletter
 
Bright Hub - Science & Technology Articles, Buyer's Guides, How-To Tips and Software Reviews
About Bright Hub | Contact Us | Advertise with Us | Become a Writer | RSS | Site Map | Terms of Use | Privacy Policy | Copyright Policy
©2009 Bright Hub Inc. All rights reserved. Page copy protected against web site content infringement by Copyscape