Using conditional formatting to hide text in a range A1:N50, by referencing values in a separate single row P1:P50

Hi folks,

I have a set of data across multiple rows/columns, for which I'm trying to use conditional formatting to hide text if it meets various criteria. I have no problem with simple criteria like "value must exceed 0.01". However, one set of criteria is that the value for all the data in a column, must exceed a reference value at the very bottom of the column.

Sample image here for a smaller dataset.

For example, in the sample image, all of the values B2:B7 which are less than or equal to B9 should be hidden, all the values C2:C7 which are less than or equal to C9 should be hidden, etc.

I'm aware that I could do this on a column-by-column basis with if-then statements. But is there an efficient way for me to use a formula in Conditional Formatting that will allow me to do this efficiently across the entire dataset?

Referring to the sample image, I would select all data B2:L7, select Conditional Formatting, and then New Rule. From here, I've tried using "Format only cells that contain", using the criterion "Less than or equal to", and then I tried entering B9:L5, but it returns an error saying that the reference can only be a single cell.

I can't seem to figure out how to use the "Use a formula to determine which cells to format" to do this and would greatly appreciate help.