Hi
I have a question for all that can possibly assist me....
I have a worksheet that returns, or displays unique matching values (on some, or all target columns in a range.
Basically: It looks up, or searches the typed-in input value and it compares it against all existing values in another part of same sheet
and when it finds a matching value to the (items / pieces), it returns a matching order# that has, or contains an exact value for that corresponding column in range.
We use excel for an order system that uses a unique order number, followed by multiple (items / pieces) which are identified by number values that are required for that specific order#.
Multiple orders across the sheet may contain some, or many cases all of matching (items / pieces).
Example: Order# 12345 "Container part #'s (items / pieces):
(12345)........1111...........2222..........3333...........4444............5555............6666.......7777.........8888
....................12345..........12345..........12345..........12345..........12345..........12345.......12345........12345
....................12346..........12344..........12341..........12341..........12340..........12344.......12347........12342
....................12348..........12348..........12348..........12348..........12348..........12348.......12348........12348
In my illustration above... Matching Order #'s are displayed beneath each (items / pieces) of the typed-in order#, when other order# contain "some, or all (items / pieces)."
In my illustrated above; (12348) is an order# that matches all criteria (items / pieces) of the typed-in target value (12345).
Is there a way to tell, or make excel highlight font green ONLY for any orders that MATCH ALL (items / pieces) found against the target typed-in target value (12345) across all corresponding columns in range. As I illustrated using the values above.
But. Do not highlight, if only a partial match is found against the (items / pieces) of target order number. from all columns (ACROSS ALL in range).
Your assistance is greatly and kindly appreciated.
Thank you!
I have a question for all that can possibly assist me....
I have a worksheet that returns, or displays unique matching values (on some, or all target columns in a range.
Basically: It looks up, or searches the typed-in input value and it compares it against all existing values in another part of same sheet
and when it finds a matching value to the (items / pieces), it returns a matching order# that has, or contains an exact value for that corresponding column in range.
We use excel for an order system that uses a unique order number, followed by multiple (items / pieces) which are identified by number values that are required for that specific order#.
Multiple orders across the sheet may contain some, or many cases all of matching (items / pieces).
Example: Order# 12345 "Container part #'s (items / pieces):
(12345)........1111...........2222..........3333...........4444............5555............6666.......7777.........8888
....................12345..........12345..........12345..........12345..........12345..........12345.......12345........12345
....................12346..........12344..........12341..........12341..........12340..........12344.......12347........12342
....................12348..........12348..........12348..........12348..........12348..........12348.......12348........12348
In my illustration above... Matching Order #'s are displayed beneath each (items / pieces) of the typed-in order#, when other order# contain "some, or all (items / pieces)."
In my illustrated above; (12348) is an order# that matches all criteria (items / pieces) of the typed-in target value (12345).
Is there a way to tell, or make excel highlight font green ONLY for any orders that MATCH ALL (items / pieces) found against the target typed-in target value (12345) across all corresponding columns in range. As I illustrated using the values above.
But. Do not highlight, if only a partial match is found against the (items / pieces) of target order number. from all columns (ACROSS ALL in range).
Your assistance is greatly and kindly appreciated.
Thank you!
