Google-sheets – Filter cells based on multiple data in 2 columns

conditional formattinggoogle sheets

enter image description here

Hi,

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

Best Answer

See File

Conditional Formatting contains following formula

ARRAYFORMULA(IF(COUNTIF(SPLIT($A1&","&$B1,","),">60")>2,TRUE,FALSE))

where $A1&","&$B1 are first cells of range of your data (can be adjusted).

Related Topic