Add A Single Expression For Conditional Formatting Across All Cells

I have a large spreadsheet in which I have reached the limit for conditional formatting. (i.e. 2050 rows)

To resolve this I can add a single expression for conditional formatting across all cells. This means I need to create a more complex expression.

I effectively have two types of conditional formatting that are very similar. I have the standard “Yes”, “No” & “A/L” which I wand to shade accordingly. I then have alternating columns of “ Yes “, “ No “, “ A/L “. I have introduced spaces to stop these values from being counted by another formula but still display yes and no. I want the shading to be the same in both cases.

I have built the following expression which does not seem to work.

=ISNUMBER(SEARCH("Yes",(ADDRESS(ROW(),COLUMN()))))

The two components of the expression work separately:

=ISNUMBER(SEARCH("Yes",P3))

=ADDRESS(ROW()-1,COLUMN())