View original (French)

Conditional Formatting / If Cell CONTAINS a Word

Solved
1i1oo Posted messages 18 Status Membre -  
PapyLuc51 Posted messages 4565 Registration date   Status Membre 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 réponse

Réponse 1 / 1
PapyLuc51 Posted messages 4565 Registration date   Status Membre Last intervention   1 510
 
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
1i1oo Posted messages 18 Status Membre
 
Perfect! Quick!!
Thank you very much!
0
PapyLuc51 Posted messages 4565 Registration date   Status Membre Last intervention   1 510 > 1i1oo Posted messages 18 Status Membre
 
To be confirmed by clicking on "resolved" to help others

Best regards
0