I am using Conditional Formatting in Excel. I am trying to compare text in one column to text in another column, but the text in the one of the columns is included within other text.
So, for example, a cell in column A includes the phrase: "I use Excel everyday" and a cell in column B includes the phrase "use Excel". I am trying to figure out whether the phrase "use Excel" in column B appears in column A, even though it is included within other text.
My entire spreadsheet is like this. Column B is a fragment of text in Column A.
If I click on Conditional Formatting, New Rule, Format Only Cells That Contain, Specific Text...
Solved by O. Q. in 25 mins