Forum Discussion
Need help with conditional fomatting formula based in text on cells
Hi everyone, I have a list of owners' names in column C. C2 contains 1+1 CAR CORPORATION C3 contains 8-J ENTERPRISES, LLC C4 contains LOYD RENTALS LLC C5 contains SMITH PAUL & PAULA C6 conta...
If to slightly modify previous ones
=SUM( COUNTIFS(C1, "* " & $G$2:$G$5 & "*" ) )=REGEXTEST($C1,"(?<=\s)(CORPORATION|LLC|INC|ENTERPRISES)")