Highlighting a row that contains text other than one word

[snwbrdr19]

Hi everyone, I'm trying to use conditional formatting to highlight (green) a row if a particular cell in that row:

• contains any text at all

Also, I'd like the row to highlight a different color (red) if a particular cell in that row:

• is empty

OR

• contains the word "batch"

Any idea how to do this? I've attached an example.

Thank you!

[JohnTopley]

Your file and thread don't agree; do want blank/batch highlighted or not? and does text mean anything i.e. could be number?

[dflak]

Try this - note the order of the rules and the stop if True.

The formula for the red condition is: =OR(ISBLANK(E2),ISNUMBER(FIND("BATCH",UPPER(E2))))