Put this formula in cell U2 and copy it down the column: =IF(COUNTIF(A2:T2,"Yes")>0,"No","Yes")