put in this formula in G2:
=OR(ISNUMBER(SEARCH({"from ABC group","From PQR group","From XYZ group"},$A2)))
or:
=SUM(COUNTIF($A2,{"*from ABC group*","*From PQR group*","*From XYZ group*"}))>0
or use asterisk for this list in G1:G4:
Activity Type
*from ABC group*
*From PQR group*
*From XYZ group*
Bookmarks