I'm looking for assistance in the formula for conditional formatting. I want excel to highlight the row if $E12 does not contain the text that resides in $V12. It does not have to be an exact match, but it needs to contain the words at minimum of whats in $V12. For example, if $E12 said "Engineer / BLD SYSTEM" and V12 states "Engineer" that would not highlight as the first cell contains the word engineer.

I took a stab at it, but it did not work:

=$E12<>"*" & $V12 & "*"

Thanks for the help.