Google Sheets: Count number of times conditional formatting equals TRUE

I am attempting to use a conditional formatting formula in my Google Sheet located here for Row 24 to count the number of times my existing conditional formatting formulas returns TRUE for each cell in the column above, and to turn RED if that number is larger than 0.

Snipaste_2023-04-10_09-01-52.png

My existing conditional formatting is successfully turning cells in Rows 2:22 RED when:

1. A cell contains either a '✘' or a '4'
2. An entry is outside the upper and lower limits defined for each row by variables on a second DATA sheet. This formula checks for either a '±' or a '-' symbol and applies the appropriate limits defined for each one:

Please Login or Register  to view this content.

I can successfully use this formula in Row 24 for the first condition:

Please Login or Register  to view this content.

But what I can't figure out is how to check for the second condition. How might I best accomplish this?

You would use an IF(COUNTIF(.................)>0) type formula that includes rules to check the same conditions as your current conditional formatting rules.

That is where I am struggling though, and I suspect it might have something to do with the ROW function parts of the formula. This is the closest I can get using COUNTIF:

Please Login or Register  to view this content.

but it's only counting the first cell in the column (Cell J7) and ignoring any other occurrences.