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...
Try the following formula in custom conditional formula rule.
=OR(REGEXTEST(TEXTSPLIT($C1," "),"CORPORATION|LLC|INC|ENTERPRISES"))