I need to create a conditional filter where at least 3 of the numbers in either cell is greater than 60. I have highlighted the rows in bold that qualify.
The first one (lets call them a1 and b1 ) do not qualify as only 1 number is over 60
The second row (a2 and b2) qualifies as there are 3 numbers in that row over 60, 74,85,80
It does not matter if the numbers of 60 are in a single cell in the row or a mixture of both as shown below
Thank you, I look forward to your solution