Conditional Formatting Question

I've included an attachment here with an example of what I'm trying to do

Originally Posted by FDibbins

1. highlight the range you want to apply the conditional formatting to
2. on the home tab, styles, select CF
3. select new rule, select use formula
4. enter =$E2<>"Batch"
adjust $E3 to suite the column

Thanks for your response! What you suggested works to a certain extent. How should I adjust your formula so that it will work if there are other words/numbers within the same cell as the word "Batch"?

For example: the conditional formatting works correctly when the cell simply has "Batch" in it. It does not work, however, if "Batch 2.6 one" is in it.

Originally Posted by FDibbins

Thanks for the feedback, and Jet, thanks for the assist

Another option...
=ISERROR(SEARCH("batch",$E2))

Is there a way to alter the formula so that it won't highlight that row if E2 is empty?

Thank you!

Try

=AND($E2<>"",ISERROR(SEARCH("batch",$E2)))

Fantastic! It works perfectly.

Falcondude, Fdibbens, Jetemc, your help is much appreciated!

Glad to help!