See attached example.
I used the range A2:J12 and because of that the formulas used apply to the first row of that range, i.e. row 2 so I used these three formulas
=SEARCH("cash",$E2) - yellow
=SEARCH("check",$E2) - green
=COUNT(SEARCH("cash",$E2),SEARCH("check",$E2))=0 - red
works as expected, I think
Bookmarks