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.
Bookmarks