Conditional Formatting: highlight row based on filtered batch

Hi Mates.
Good Day.

Today i need a help with conditional formatting.

For instance, i have a table with detailed transaction where column B is batch number & i have another table in the same sheet which is summarized per batch.
Now, what i am looking for is , if detailed table is filtered by batch, i want the same batch row highlighted in table 2.
If 2 batches are selected in table 1 , both rows in table 2 needs to be highlighted.

Can be done this with formula? if not, a formula to get only unique values from table 1 is also i preferred.

I've updated your thread title: please review General Guideline #1 on the Forum Rules page.

In your mock-up, you need to illustrate what you mean.

I am not totally clear on your description, but suspect that it may require VBA.

Please filter and manually highlight to show what we are aiming for.

I think you're going to need VBA for this - shall I move the thread for you?

The thread has been moved for you.

Here is a formula based proposal that adds a column to table14.
1. The added column (Include) is populated using: =SUBTOTAL(9,[@CIF])
2. The conditional formatting formula for table25 is: =AND(SUMIFS($M$12:$M$17,$I$12:$I$17,$I4)>0,ISNUMBER(MATCH($I4,$I$12:$I$17,0)))
Let us know if you have any questions.

You're Welcome. Thank You for the feedback and for marking the thread as 'Solved'. I hope that you have a blessed day.