I'm trying to highlight a text in a sentence that matches with the word in the other column. Lets say that column A (contains 'ball', 'can') of different row B (contains 'He kicks a ball', 'He can eat that'.) of different row.

I need only the word in the sentence of column B that matches the word defined in column A to be highlighted and not the whole sentence. Is it doable? And how is it done?

enter image description here

  • This can only be done with VBA, and even then it's not trivial. Do you want to pursue that? – teylyn Jun 29 '17 at 2:38
  • Thanks for your reply, but if it is that difficult, i will just do it manually. – teamking12 Jun 29 '17 at 2:46

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.