=$C2="完了"

=ISNUMBER(E2)

=ISTEXT(E2)

=AND(ISNUMBER(E2),E2>100)

=COUNTIF(INDIRECT("売上!$A$2:$A$7"),A2)>0
