questions: #1) What do you mean by "highlight the row"? #2) will this be an "exact" match? or partial contents of the cells? #3) can we add a "helper" column and filter? #4) How many rows are we talking about? #5) does it have to be a FORMULA? can you use VBA?
If we add a new column (either at the beginning or end) then we can use a HLookup function to search for a matching value, combine that with aniferr() function, and we can then "flag" the row that contains the value. using Filters, then you can display only that row. This won't "highlight" the row and it won't work well with a large number of rows. I could easily create a VBA macro that could clear the highlighting search for the specified value highlight the row (in any way you wish) but that is not a formula. Paul ----------------------------------------- “Do all the good you can, By all the means you can, In all the ways you can, In all the places you can, At all the times you can, To all the people you can, As long as ever you can.” - John Wesley ----------------------------------------- ________________________________ From: JohnA <johnasmit...@gmail.com> To: excel-macros@googlegroups.com Sent: Tue, February 5, 2013 1:56:21 PM Subject: $$Excel-Macros$$ Re: Conditional Format Entire Row if Any Column has a specific value I wasn't clear enough so I created an example of my question. Thank you all for quick responses. My target value can be in none or one or many of the 180 columns, not interdependent on each other, and not in the same column on different rows. Please see the attached example for a more clear view of my challange. Again thank you for your help. John On Tuesday, February 5, 2013 10:05:08 AM UTC-5, JohnA wrote: I have a spreadsheet with 180 columns and 8,000 rows. I would like to highlight a row if a specific value is anywhere in the spreadsheet. (for example in cell K23 = 234 and H112 = 234, then both row 23 and 112 are highlighted). > >Please help with the formula to accomplish this. Thank you. > >John-- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. For more options, visit https://groups.google.com/groups/opt_out. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. For more options, visit https://groups.google.com/groups/opt_out.
