Forum Discussion
Formulas
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 : mailto:shevaa262@gmail
2 Replies
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.
abdou_el96 I just joined this community. You can use conditional formatting > highlight cell rules > More rules > Select the preference and set the rules.
