Highlight Rows with Conditions met
Solved/Closed
PMARI
-
Jul 28, 2011 at 07:55 AM
rizvisa1
rizvisa1
- Posts
- 4479
- Registration date
- Thursday January 28, 2010
- Status
- Contributor
- Last seen
- May 5, 2022
Related:
- Highlight Rows with Conditions met
- Excel copy row if condition met ✓ - Forum - Excel
- Copy rows to new sheets if condition is met ✓ - Forum - Excel
- Copy row if condition met excel ✓ - Forum - Excel
- How to copy a data from one sheet to another, when specific criteria is met - Forum - Excel
- Vba to copy and paste rows if condition is met ✓ - Forum - Excel
1 reply
rizvisa1
Jul 28, 2011 at 01:32 PM
- Posts
- 4479
- Registration date
- Thursday January 28, 2010
- Status
- Contributor
- Last seen
- May 5, 2022
Jul 28, 2011 at 01:32 PM
Have you looked at conditional formatting ?
Sorry cannot look at speedy share from work but conditonal format has been answered many times
Sorry cannot look at speedy share from work but conditonal format has been answered many times
Aug 1, 2011 at 09:53 AM
I looked at PMARI's file and can't find a solution. Now I'm curious how you would solve this. Hopefully you can acces "send space" since that is the site I used to upload his file.
Apparently Kisokea is blocking "send space" since my message doesn't stick. That is why I had to break it up.
"http://www.send
space.com/file/r0vc9c"
Best regards,
Trowa
Aug 1, 2011 at 10:22 AM
Aug 1, 2011 at 10:41 AM
He only wants orders with one specific type of fruit to be moved to another sheet.
So when you look at his first order number (100212) it contains Mango, Apple, Pineapple and Cherry. This order needs to be left alone since it contains multiple types of fruit.
Order 14568 only contains Mango, so this order needs to be moved.
Order 302154 only contains Papaya, but this is not the particular fruit he mentioned in red, so this orde needs to be left alone as well.
When you go by this logic only the four orange lines needs to be moved (to the next sheet or like he did in his file to range G8:K11).
So I was thinking about an inputbox which will let you input the fruitname. Then search through the order numbers for a unique order which matches the inputted fruitname.
But to make things a little more complicated, there can also be an order number with two rows of the same fruit, thus making the order number not unique any more.
Hopefully this clearify's the issue.
BTW it took me quite some time looking at his sheet thinking about what he could mean. For me that is part of the fun in solving query's.
Best regards,
Trowa
Aug 1, 2011 at 01:34 PM
Aug 2, 2011 at 09:40 AM
PMARI should be pleased.
Best regards,
Trowa