Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Search for first instance of number greater than x -VBA Excel
I'll try it! Thanks!- dhigby
- Post #8
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Search for first instance of number greater than x -VBA Excel
The match function seems to be looking for a specific value. The value I am seeking is the first number greater than 50, which can be variable. Is there a way to get the match function to look for a variable? The conditional formatting seems like it would highlight all rows with value...- dhigby
- Post #6
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Search for first instance of number greater than x -VBA Excel
Hi Skip, here is a sample of the data: MOD01 0132 32 MOD01 0131 37 MOD01 0130 41 MOD01 0129 46 MOD01 0126 48 MOD01 0125 53 MOD01 0124 57 MOD02 0132 38 In this example, the line MOD01 0125 53 Would be highighted. My standby of recording my steps is not working for me here. I think i would be...- dhigby
- Post #3
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Search for first instance of number greater than x -VBA Excel
Can you help me please? Here's what I want to do. o for [column a] equal x, look at [column c] o if [col c] greater than 50, highlight columns a - c in that row in yellow. else, next row. o once one number greater than 50 is found and highlighted, go to next [col a] (in other words, don't...- dhigby
- Thread
- Replies: 8
- Forum: VBA Visual Basic for Applications (Microsoft)
