Forum Discussion

Muemi's avatar
Muemi
Copper Contributor
Sep 08, 2020
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...
excel
  • SergeiBaklan's avatar
    SergeiBaklan
    Sep 08, 2020

    Bennadeau 

    As a cosmetic comment, simple

    =SEARCH($A1,B1)

    If it returns an error format trigger won't work

Bennadeau's avatar
Bennadeau
Iron Contributor
Sep 08, 2020

Hi Muemin, 

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

And apply it to all your cells.

 

 

SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Sep 08, 2020

Bennadeau 

As a cosmetic comment, simple

=SEARCH($A1,B1)

If it returns an error format trigger won't work

  • Muemi's avatar
    Muemi
    Copper Contributor
    Sep 09, 2020
    I t works perfectly. Thank you Bennadeau & @SergeiBaklan
    • SergeiBaklan's avatar
      SergeiBaklan
      Diamond Contributor
      Sep 09, 2020

      Muemi , you are welcome

Resources