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 contains DOE JHON & JANE
C7 contains MENENDEZ JAMES
C8 contains BROWN INVESTMENTS, INC.
And so on
I'd like to highlight the whole row for the cells that have CORPORATION, LLC, INC, ENTERPRISES in their names.
Hope this makes sense and someone can help me.
Thank you.
2 Replies
Try the following formula in custom conditional formula rule.
=OR(REGEXTEST(TEXTSPLIT($C1," "),"CORPORATION|LLC|INC|ENTERPRISES"))This is the rule for conditional formatting in my sample file.
=SUM(N(ISNUMBER(SEARCH($G$2:$G$5,C2))))This is the "applies to" range in the sample.
=$C$2:$C$8
