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.
Bookmarks