Forum Discussion
Solved
Conditional formatting row by row (text contains)
I would like to colour cells which contain the word from column A but only those which are in the same row. There are over 10000 rows, so it should be easily adaptable to other rows. Example: 1st d...
As a cosmetic comment, simple
=SEARCH($A1,B1)If it returns an error format trigger won't work
You may apply rule with the formula like
=ISNUMBER(SEARCH("dog",A1))to your entire range (1000 row) if the range starts from A1