View original (French)

Conditional Formatting / If Cell CONTAINS a Word

Solved
1i1oo Posted messages 18 Status Member -  
PapyLuc51 Posted messages 4567 Registration date   Status Member Last intervention   -
Hello,
I would like to apply the formatting of 4 lines in the same column based on the value of another cell (same column but different row) if it contains the word "Sample".
I said "CONTAINS" and not "EQUAL TO"... and therein lies my problem...
What formula should I apply?

Thank you for your help.

Best regards.

1 answer

  1.
    PapyLuc51 Posted messages 4567 Registration date   Status Member Last intervention   1 511
     
    Hello

    Selection of the 4 cells to compare with A1 to be corrected according to the table

    The conditional formatting formula

    =COUNTIF($A$1;"*sample*")>0

    Best regards
    4
    1. 1i1oo Posted messages 18 Status Member
       
      Perfect! Quick!!
      Thank you very much!
      0
      1. PapyLuc51 Posted messages 4567 Registration date   Status Member Last intervention   1 511 > 1i1oo Posted messages 18 Status Member
         
        To be confirmed by clicking on "resolved" to help others

        Best regards
        0