Occasional Visitor

hello, everyone, I'm new here and I would like it if you help me with excel formulas.


I want from excel to color a cell if these 3 words are not writing on it basic, Moyenne and complete


in other words, if I type a word except for basic or Moyenne or complete the cell will be colored with red and the word in the white 


please can you help me with this 

here is my email :

2 Replies

@abdou_el96 I just joined this community. You can use conditional formatting > highlight cell rules > More rules > Select the preference and set the rules. 


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.