Conditional formatting "Highlight text" if all columns in range match criteria.

[tazmtiger]

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!

 

[Marcelo Branco]

Maybe...

	A​	B​	C​	D​	E​	F​	G​	H​	I​
1​	12345​	1111​	2222​	3333​	4444​	5555​	6666​	7777​	8888​
2​		12345​	12345​	12345​	12345​	12345​	12345​	12345​	12345​
3​		12346​	12344​	12341​	12341​	12340​	12344​	12347​	12342​
4​		12348​	12348​	12348​	12348​	12348​	12348​	12348​	12348​

<tbody>
</tbody>

Select B2:I4

Home > Conditional Formatting > New rule > Use a formula...

Insert this formula
=COUNTIF($B2:$I2,$B2)=COLUMNS($B2:$I2)
Format button pick Fill --> Green

Hope this helps

M.