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 & ","))
)

 

posted @ 2025-05-04 10:08  别动我的猫  阅读(80)  评论(0)    收藏  举报