Sep 08 2020 08:38 AM
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?
Sep 08 2020 09:04 AM
You may apply rule with the formula like
=ISNUMBER(SEARCH("dog",A1))
to your entire range (1000 row) if the range starts from A1
Sep 08 2020 09:08 AM
Hi @Muemin,
Try this in your conditional formatting. =IF(SEARCH($A1,B1)>0,TRUE,FALSE)
And apply it to all your cells.
Sep 08 2020 10:46 AM
SolutionAs a cosmetic comment, simple
=SEARCH($A1,B1)
If it returns an error format trigger won't work
Sep 09 2020 12:24 AM
Sep 09 2020 03:10 AM
@Muemi , you are welcome
Sep 08 2020 10:46 AM
SolutionAs a cosmetic comment, simple
=SEARCH($A1,B1)
If it returns an error format trigger won't work