How to apply conditional formatting search for multiple words in Excel? 2018/10/08 Tutorial =SUM(COUNTIF(A2,”*”&Mylist&”*”)) Source: How to apply conditional formatting search for multiple words in Excel?