Re: $$Excel-Macros$$ Conditional Formatting
Attached. On Tuesday, 26 November 2013 18:06:00 UTC, ashish wrote: can u share a sample file On Tue, Nov 26, 2013 at 11:19 PM, anon nicmo...@googlemail.comjavascript: wrote: Hi all, Using conditional formatting, how can I highlight the smallest-valued cell which is greater than 1.5? Thanks. -- 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...@googlegroups.com javascript:. To post to this group, send email to excel-...@googlegroups.comjavascript: . Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out. -- *Regards* *Ashish Koul* *Visit* http://www.excelvbamacros.in Like Us on Facebookhttp://www.facebook.com/pages/Excel-VBA-Codes-Macros/15180389897 Join Us on Facebook http://www.facebook.com/groups/163491717053198/ P Before printing, think about the environment. -- 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. For more options, visit https://groups.google.com/groups/opt_out. Book5.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
$$Excel-Macros$$ Conditional Formatting
Hi all, Using conditional formatting, how can I highlight the smallest-valued cell which is greater than 1.5? Thanks. -- 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. For more options, visit https://groups.google.com/groups/opt_out.
$$Excel-Macros$$ Re: find method does not work in filtered (hidden) ranges
Yes, I could do it that way. I try to avoid loops as much as possible though. I was curious if there was a way, because it seems odd that you can not see filtered data. On Jun 8, 10:40 pm, Dave Bonallack davebonall...@hotmail.com wrote: Hi, If the FIND thingy doesn't work with filter-hidden rows, try just looping through each cell in the range you want: Something like: For each c in Range(A2:A1000) If c.value = Your criteria here Then Msgbox Bing! It's here! Next c Replace the Message Box with whatever code you need. Hope this is of some help. Regards - Dave. Date: Mon, 8 Jun 2009 08:47:12 -0400 Subject: $$Excel-Macros$$ Re: find method does not work in filtered (hidden) ranges From: youcanthavemyemailaddr...@gmail.com To: excel-macros@googlegroups.com I know it has to be done with a macro. I'm just not sure how (and if it is possible) to use the find method and search in rows hidden by a filter. If you have an idea let me know. Thank you. On Sat, Jun 6, 2009 at 1:11 AM, Nishant Jainnishantjai...@gmail.com wrote: this is possible if you want to use macro... i hope you can develop one, but if not let me know... On Jun 6, 2:29 am, Anon Ymous youcanthavemyemailaddr...@gmail.com wrote: Hello. First post here (and first post to a Google group). I have been a long time user of the Ozgrid forum, but I am against the idea of paying to post. Hopefully I'll find some nice and helpful people here. :) Ok, so the find method works on visible and hidden rows depending if you use LookIn:=xlValues or xlFormulas; however, it does not work on hidden rows caused by a filter. I have a range that is filtered, and I want to find a value in a column that may or may not be the filter criteria (and thus hidden). I do not want to show all the data, do the find, then reapply all the filters again. Ideas? _ Looking for a new car this winter? Let us help with car news, reviews and morehttp://a.ninemsn.com.au/b.aspx?URL=http%3A%2F%2Fsecure%2Dau%2Eimrworl... --~--~-~--~~~---~--~~ - Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com - -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: find method does not work in filtered (hidden) ranges
I know it has to be done with a macro. I'm just not sure how (and if it is possible) to use the find method and search in rows hidden by a filter. If you have an idea let me know. Thank you. On Sat, Jun 6, 2009 at 1:11 AM, Nishant Jainnishantjai...@gmail.com wrote: this is possible if you want to use macro... i hope you can develop one, but if not let me know... On Jun 6, 2:29 am, Anon Ymous youcanthavemyemailaddr...@gmail.com wrote: Hello. First post here (and first post to a Google group). I have been a long time user of the Ozgrid forum, but I am against the idea of paying to post. Hopefully I'll find some nice and helpful people here. :) Ok, so the find method works on visible and hidden rows depending if you use LookIn:=xlValues or xlFormulas; however, it does not work on hidden rows caused by a filter. I have a range that is filtered, and I want to find a value in a column that may or may not be the filter criteria (and thus hidden). I do not want to show all the data, do the find, then reapply all the filters again. Ideas? --~--~-~--~~~---~--~~ - Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com - -~--~~~~--~~--~--~---