Thank you Viper ever so much!!! John
On Wed, Feb 6, 2013 at 1:20 AM, The Viper <viper....@gmail.com> wrote: > pfa > > you can modify the range on formula as desired. > > > On Wed, Feb 6, 2013 at 9:34 AM, John A. Smith <johnasmit...@gmail.com>wrote: > >> Paul, >> >> #1) By using conditional formatting, highlight any row the EXACT target >> value is in regardless of the column it's in >> #2) Has to be an EXACT match >> #3) Helper columns are okay >> #4) Rows quantity varies but can be between several hundred to >> approximately 8-9,000 >> #5) Can be either formula or VBA >> >> Each row is an individual event and I need to quickly see only the rows >> where somewhere in the 180 columns is a specific target value (I wanted to >> make cell A1 where you would enter the target value to trigger the >> highlighting). >> >> >> Thank you for your help. >> >> John >> >> >> On Tue, Feb 5, 2013 at 3:44 PM, Paul Schreiner >> <schreiner_p...@att.net>wrote: >> >>> 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. >>> >>> >>> >> >> -- >> 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. > > > -- 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.
