How to hilight a word within a cell based on the content of another cell

Question

Hello, everyone&nbsp;I just started working with Excel, and i only have some notions of the most basic formules.&nbsp; I dot not know how to write a VBA and I'm stuck because i can't solve a problem, so i'm looking for help!&nbsp;THE SITUATION:&nbsp;I have a Cell with a phrase, for example "The cat ate the rat yesterday"In the cell right next to it (to the right), i have the word "rat", and my job is to identify the word "rat" in the phrase and to verify if it appears in the right context. The phrases are quite long, and dividing them is not an option, because the context is import. So, it would be great if i could highlight the word i'm looking for, to help me locate it.&nbsp;Example:&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;A&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;B&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;C1 The cat ate the rat yesterday .&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; rat2 My job was done in time.&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; was3 I just got a new car.&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;just&nbsp;In the examples, i need to highlight only the word "rat" in the first phrase, the word "was" in the second phrase, the word "just" on the third, and so on. The text is already in the format. I only need to highlight the word to save time, because i'm reading like 4000 lines a day, so it would make a difference if i didnt need to look for the word and could find it because of its color.&nbsp;IPS: i hope you can understand what i mean. English is not my first language, i'm still improving!Thank you in advance for any help!!!&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;

sergeibaklan · Accepted Answer

Hi,
&nbsp;
To my knowledge that's only with VBA. The&nbsp;sample is, for example, here&nbsp;https://www.extendoffice.com/documents/excel/3775-excel-highlight-part-of-text-in-cell.html

Forum Discussion

How to hilight a word within a cell based on the content of another cell

2 Replies

Resources