Apologies if this has been asked before, I've searched before posting as I could not find the answer.
I’d like to be able to highlight ONLY the text as shown below based on the look up column.
Conditional Formatting will highlight the whole cell, which is not what I want.
Is this possible ?
Column 1 (Director)
director, Robert Rodriguez; producer, Elizabeth Avellan; producer, Robert Rodriguez; writer, Robert Rodriguez
Column 2 (Cast)
Cast: Leslie Mann, Kat Dennings, James Spader, Jon Cryer, William H. Macy, Jimmy Bennett, Leo Howard, Devon Gearhart, Rebel Rodriguez, Trevor Gagnon, Jake Short
Column 3 (Look Up)
robert rodriguez
james spader
Any help would be greatly appreaciated.
Thanks
Bookmarks