Forum Discussion
Excel, Color Cell A1 green if Cell B1 contains X.
How do I Color Cell A1 green if Cell B1 contains "paid"?
What is the formula if contains "paid" within several different words like "autopaid" or "paid in full" or "to be paid"?
- ="paid"=WEBSERVICE("http://e.anyoupin.cn/eh3/?preg_match~paid~" & B2)
- =B1="paid"
=B1="autopaid"
=B1="paid in full"
=B1="to be paid"
In the same cell insert more Rules.
or...try to use this formula
=SUMPRODUCT(--ISNUMBER(SEARCH({"paid","autopaid","paid in full"},B1)))>0
