Conditional Formatting, match a list to multiple columns

[ExcelNightmare]

I have a list of values on another sheet that I want to try and match to two columns (there are multiple lists to match to different sets of columns so something easy to repeat would be great). If one of the values in the given list (changeable) matches a value in the columns, the whole row would be highlighted. The list values can match either one of the two columns or both.

After all the matches are highlighted, I want to count the amount of rows highlighted.

So far I have used:

=MATCH($P1,Search!$B$4:$B$40,0) #to find values in the column to match the list but I had to repeat it multiple times as it seems MATCH does not handle multiple columns
=MATCH($R1,Search!$B$4:$B$40,0)
Is there a way to put them together? I have over 30 conditional formatting now....

Also I have used Filter and "=SUBTOTAL(102,Data!I:I)" to count the number of rows highlighted, is there a better way?

 

[ExcelNightmare]

Really need help, please
Excel is crashing with the multiple conditional formats