Forum Discussion
Formulas
If only one of the excluded words could show up in a cell, select the whole data range, use Conditional Formatting with formula rule =XOR(ISERROR(SEARCH("basic",F2)),ISERROR(SEARCH("moyenne",F2)),ISERROR(SEARCH("complete",F2))) and format red fill with white text
However, if the excluded words may show up at the same time in a cell, select whole data range, choose red fill with white text. Then apply Conditional formatting with formula rule =OR(IFERROR(SEARCH("basic",$A2)>0,0),IFERROR(SEARCH("moyenne",$A2)>0,0),IFERROR(SEARCH("complete",$A2)>0,0)) and format no fill with automatic text color
If either solution works for your purpose, simply copy cell F2 (solution 1) or A2 (solution 2) in the attached workbook and paste special format to anywhere you want to apply the rule and formatting.