SOLVED

Conditional formatting row by row (text contains)

Copper Contributor

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 dog: -> dog walker -> cat
2nd cat: -> dog -> hamster
3rd hamster: -> hamster food -> hamster cage

All cells in line 1 which contain dog should be coloured and so on. Can someone help me?

5 Replies

@Muemi 

You may apply rule with the formula like

=ISNUMBER(SEARCH("dog",A1))

to your entire range (1000 row) if the range starts from A1

Hi @Muemin, 

Try this in your conditional formatting. =IF(SEARCH($A1,B1)>0,TRUE,FALSE)

And apply it to all your cells.

Bennadeau_0-1599581244176.png

 

 

best response confirmed by Muemi (Copper Contributor)
Solution

@Bennadeau 

As a cosmetic comment, simple

=SEARCH($A1,B1)

If it returns an error format trigger won't work

I t works perfectly. Thank you @Bennadeau & @SergeiBaklan

@Muemi , you are welcome

1 best response

Accepted Solutions
best response confirmed by Muemi (Copper Contributor)
Solution

@Bennadeau 

As a cosmetic comment, simple

=SEARCH($A1,B1)

If it returns an error format trigger won't work

View solution in original post