Formula in conditional formating

I am trying to set a conditional format in a column that is based on two requirements - that a relative cell in another column (G) is not blank and that the formatted cell (in column J) does not contain a certain string of characters within the text (TRX139 - which could appear anywhere in the text).

The formula I finally came up with was =AND($G2<>"",($J2<>"*TRX139*")). But it's not working and I'm fried and need to move on to another task for a while.

Can anyone help me solve this before I get back to it?

Thanks,

Bryan

Try this:

=AND($G2<>"",ISERROR(FIND("TRX139",$J2)))