Find and mark the row matching the numbers

[ilan76]

Hello Everyone,

I would like to create a rule that finds a set of numbers in a table and highlights the rows that matches the exact numbers:

- All numbers must match in a row in order to highlight the rows.
- Numbers order is not important.
- Advanced: ability to control how many of the numbers to find and match in a row (minimum, etc.)


Appreciate your help, Thank you.

 

[Capt.Ragnar]

- Advanced: ability to control how many of the numbers to find and match in a row (minimum, etc.)
.

I don't understand this.

For the rest you just use conditional formatting and use a formula to determine when the formatting is on or off. You may have to create a column that you can hide later to preform the "test" of format the row or not.

 

[ilan76]

Hi,

Can you please show an example how to do this?
for example - I want to find the numbers : 33, 45, 78, 23, 89, 12 (which is set in columns row top right).
There is table of rows with numbers, and I want to be able to find the rows (color/highlight) with matches all 6 numbers.
The advanced option is being able to match according to my specifications - match at least 4 numbers or 5, etc.

Thanks

 

[Capt.Ragnar]

If you want to PM me your email address I can send you the dropbox link.

 

[ilan76]

Sent you a PM with my email address.
Thank you very much.