-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

Hennes
  • 64,768
  • 7
  • 111
  • 168
Lili
  • 1
  • 1
  • 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 '16 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 '16 at 13:44
  • Revelant?: [Excel 2013 Fuzzy Lookup to find near-duplicate text](http://superuser.com/q/926382) – DavidPostill Jul 13 '16 at 14:06

1 Answers1

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.

Cand3r
  • 2,687
  • 1
  • 9
  • 24