指定字母出現任一 顯色 (12846)

A1:A16 格式化=SUMPRODUCT(ISNUMBER(0/(FIND(C$2:C$9,"#"&A1)>1))*1)

另解=sumproduct(($C$2:$C$9<>"")*isnumber(find($C$2:$C$9,a1))*1)>0