New answers tagged


Apply conditional formatting with custom formula =arrayformula(sum(N(not(isnumber(A3:A)))))=0 This can be applied even to a range of headers such as A1:E1; the formula, entered as above, will be interpreted in a relative way for other columns. Explanation not(isnumber(...)) is true if the entry is not a number N converts logical true/false to integers ...


The way I managed to do this, even though it will be very cumbersome if you have multiple rows that you need to check, is by using the following equation coupled with the Conditional Formatting feature (Format > Conditional Formatting): =IF(AND (ISNUMBER(n), ISNUMBER(n1), ISNUMBER(n2)), True, False) Where "n" is whatever cell you're checking.


As Rubén said, conditional formatting is for human consumption only: neither sheet formulas nor scripts can access it. You should create a column that records the fact of "all answers are correct", and then filter by that column. For example, put in E2 =arrayformula((C2:C=2)*(D2:D=4)) which will put 1 in every row where both answers are correct. Then ...

Top 50 recent answers are included