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...
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