Forum Discussion
Phil_Grant_Popi
Oct 16, 2023Copper Contributor
Excel, Color Cell A1 green if Cell B1 contains X.
How do I Color Cell A1 green if Cell B1 contains "paid"?
Phil_Grant_Popi
Oct 16, 2023Copper Contributor
What is the formula if contains "paid" within several different words like "autopaid" or "paid in full" or "to be paid"?
peiyezhu
Oct 17, 2023Bronze Contributor
="paid"=WEBSERVICE("http://e.anyoupin.cn/eh3/?preg_match~paid~" & B2)