-2

I am not pro in Excel. I have an excel table that I need to find similar values and highlight the the remaining texts.

I have read some questions here but it was not helpful in my case.

I would appreciate if you could help me.

Thanks in advance,

Best Regards, Lili

Improve this question
3
  • Answer for your question is far beyond scope of this site. At first it's unclear, what similar means for you? After answering that it probably would require complex programming and as such it's off-topic, as here we answer well defined single question instead of providing entire solutions.
    – Máté Juhász
    Jul 13, 2016 at 13:20
  • 1
    To build off of what Mate said, some examples of your data, as well as what steps you've already tried to take would help quite a bit. Your question is too vague as it stands right now. It's possible there's a formulaic answer, conditional formatting, VBA scripting, etc. Screenshots of your worksheet, a clear description of what you're trying to accomplish (what terms are you trying to match), the desired outcome, and what you've already tried will help us help you.
    – jrichall
    Jul 13, 2016 at 13:44
  • Revelant?: Excel 2013 Fuzzy Lookup to find near-duplicate text
    – DavidPostill ♦
    Jul 13, 2016 at 14:06

1 Answer 1

Reset to default
0

Look into Conditional Formatting. The Conditional Formatting option is on the Home Tab in Excel in the Styles section. Here is a Support.Office.com tutorial on some of the options you have for conditional formatting.

Improve this answer

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .