Excel 条件格式 包含于多字符
Excel筛选数据公式 =OR( ISNUMBER(SEARCH(",03,", "," & $E1 & ",")), ISNUMBER(SEARCH(",08,", "," & $E1 & ",")), ISNUMBER(SEARCH(",10,", "," & $E1 & ",")), ISNUMBER(SEARCH(",15,", "," & $E1 & ",")), ISNUMBER(SEARCH(",16,", "," & $E1 & ",")), ISNUMBER(SEARCH(",19,", "," & $E1 & ",")), ISNUMBER(SEARCH(",20,", "," & $E1 & ",")), ISNUMBER(SEARCH(",24,", "," & $E1 & ",")), ISNUMBER(SEARCH(",38,", "," & $E1 & ",")), ISNUMBER(SEARCH(",46,", "," & $E1 & ",")), ISNUMBER(SEARCH(",49,", "," & $E1 & ",")), ISNUMBER(SEARCH(",52,", "," & $E1 & ",")), ISNUMBER(SEARCH(",55,", "," & $E1 & ",")), ISNUMBER(SEARCH(",63,", "," & $E1 & ",")), ISNUMBER(SEARCH(",65,", "," & $E1 & ",")), ISNUMBER(SEARCH(",71,", "," & $E1 & ",")), ISNUMBER(SEARCH(",75,", "," & $E1 & ",")), ISNUMBER(SEARCH(",76,", "," & $E1 & ",")), ISNUMBER(SEARCH(",79,", "," & $E1 & ",")), ISNUMBER(SEARCH(",80,", "," & $E1 & ",")) )