Conditional formatting not containing specific text - two different texts

[mikec82]

I'm trying to create a conditional formatting rule where the cell value does not contain specific text. Cells either say "mother", "father", or a number of different options. I want to find everything but "mother" or "father". Would I have to use a formula for that, or can I use "cell value" "does not contain"?

 

[bbott]

Try:

=AND(ISTEXT(A1),A1<>"father",A1<>"mother")

 

[mikec82]

Would it be "isnottext"? And pardon the beginner question, but what would the formula look like if the range is =$H:$H,$M:$M,$R:$R,$W:$W ?

 

[bbott]

Would it be "isnottext"? And pardon the beginner question, but what would the formula look like if the range is =$H:$H,$M:$M,$R:$R,$W:$W ?

I'm not sure I follow. Are you looking for conditional formatting or are you trying to find words in a range?

 

[mikec82]

Trying to find anything in range =$H:$H,$M:$M,$R:$R,$W:$W that does not contain the text "mother" or "father".

 

[bbott]

If you're literally looking for anything other than those two words you can get rid of the ISTEXT. But then it will highlight blank cells as well. Try this as the CF in H1. Use the format painter to copy the conditional formatting down:

=AND(H1<>"father",H1<>"mother")