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"?
NikolinoDE
Oct 16, 2023Gold Contributor
=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
=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