Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 10-15-2013, 02:29 PM
MSofficeBLUE MSofficeBLUE is offline Excel 2007, highlight entire row based on data found in one cell Windows XP Excel 2007, highlight entire row based on data found in one cell Office 2007
Novice
Excel 2007, highlight entire row based on data found in one cell
 
Join Date: Oct 2013
Location: Los Angeles
Posts: 2
MSofficeBLUE is on a distinguished road
Default Excel 2007, highlight entire row based on data found in one cell

Hello all,



The subject line pretty much describes what I want to do. I've read a ton online and for whatever reason I cant seem to get it to work.

I have a growing excel file with several different users. They all use 12 inch screens that are irreplaceable so i am trying to make a better visual mouse trap here.

They must use the excel file to pull info from based on using a sales order number. They currently Control F and punch in the number which highlights the cell but i think they (older employees wearing glasses) would like it better if it were to highlight the entire row the cell is in so they can have a better visual location assistant. I have tried highlighting the whole gride and doing some conditional formatting but have not had any luck with the correct formula.

Thanks for any and all assistance
Reply With Quote
  #2  
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
  #3  
Old 10-15-2013, 09:51 PM
MSofficeBLUE MSofficeBLUE is offline Excel 2007, highlight entire row based on data found in one cell Windows XP Excel 2007, highlight entire row based on data found in one cell Office 2007
Novice
Excel 2007, highlight entire row based on data found in one cell
 
Join Date: Oct 2013
Location: Los Angeles
Posts: 2
MSofficeBLUE is on a distinguished road
Default

I found the shift+space bar solution earlier and will try to give it a shot but as you mentioned it will not highlight but only frame the row. We will see if that helps for now. As for your second option it sounds good but I don't know if it's an option for us but will pitch it to our IT dept.

Thanks for your insight so far.
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 03:59 PM.


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