Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 10-15-2013, 08:57 PM
BobBridges's Avatar
BobBridges BobBridges is offline Excel 2007, highlight entire row based on data found in one cell Windows 7 64bit Excel 2007, highlight entire row based on data found in one cell Office 2010 32bit
Expert
 
Join Date: May 2013
Location: USA
Posts: 700
BobBridges has a spectacular aura aboutBobBridges has a spectacular aura about
Default

Would it suit their purpose if, having done the <Ctrl-F>, they then hit <Shift-Space>? That selects the entire row, which highlights it though not in a color you can control.



If you want a more noticeable color, all that occurs to me is a VBA solution: Set it up on their machines so that <Ctrl-F> triggers a VBA macro rather than the Find function (can we do that?). The macro acts like Find in that it receives the string and locates it in the worksheet, but then highlights the entire row in some bright color.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2007, highlight entire row based on data found in one cell Excel Cell Data in a Word doc Jagobezzer Word 1 09-30-2013 06:18 AM
Excel 2007, highlight entire row based on data found in one cell highlight text based on find command alysolyman Word VBA 1 03-27-2013 02:46 PM
Change formula cell range based on cell value Scoth Excel 4 10-25-2012 07:51 AM
Excel 2007, highlight entire row based on data found in one cell Creating formula based on if data is correct in cell MattMurdock Excel 1 08-06-2012 03:11 AM
Excel 2007, highlight entire row based on data found in one cell How to highlight the row based on cell value? Learner7 Excel 1 12-11-2011 02:28 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 10:00 AM.


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