How to check if all cells in a non congruent range/list meet specific criteria. See below.

spinaz0070  I'm sure it's possible to come up with a more elegant solution than this. But as a pointer to you in terms of developing a formula that can work, you might try -- as I've done in the attached --with a smaller set of cells replicating the condition you're looking for. Then when you get something that works, you could extend it. BUT, see my concluding comment at the bottom.

Here are shown the three formulas I've used that work for just three cells with disparate values. These could be combined into one that just checks to make sure each produces the full count showing that all satisfy your "PASS" criteria.

However, I wonder whether you couldn't redesign your sheet so that the values being checked ARE contiguous.....that would make more sense, in the long run. Even if there's some other process in the cells in the midst of these, you could have these crucial cells for the Pass/Fail in a different location, as a single range.