Excel - How to Use Conditional Formatting With IF Statement - Expert Solution

Question description:
This user has given permission to use the problem statement for this blog.

I need a formula to find similarities in one column of excel data (12,000 rows) that would clearly indicate the cells that are extremely similar to another cell, even if not a direct match. I tried fuzzylookup and that would not work as well as the conditional formatting rules.
Solved by T. C. in 20 mins
This is the chat thread from the real Excelchat help session. It contains no private user information.
Excelchat Expert 11/06/2018 - 01:39
Excelchat Expert 11/06/2018 - 01:39
Welcome to Got it Pro
User 11/06/2018 - 01:39
thanks, can you help me
Excelchat Expert 11/06/2018 - 01:39
Can you elaborate on your requirement so that i can help
Excelchat Expert 11/06/2018 - 01:41
DO you have some sample data so that i can help
User 11/06/2018 - 01:41
I need to create one list of company names. Currently I have a list of 12,000 with similairites and matches within the data. However, the data doesn't have any exact matches anymore due to differences with text input. I need to narrow down the list to make sure the company only appears once and need a formula to clearly indicate what cells are the same
User 11/06/2018 - 01:41
no I dont
User 11/06/2018 - 01:42
if you look at the document preview, that's the idea I'm talking about. They are all clearly ace but not exact matches
Excelchat Expert 11/06/2018 - 01:43
please explain what do you want
User 11/06/2018 - 01:44
I want a formula that will make it clear that two cells are basically the same even if they arent an exact match
User 11/06/2018 - 01:46
Excelchat Expert 11/06/2018 - 01:47
how would want them to be clear?
Excelchat Expert 11/06/2018 - 01:47
Do you want to split these up?
User 11/06/2018 - 01:47
I want the cells to be highlighted or sent to a new list to indicate they are similar
Excelchat Expert 11/06/2018 - 01:48
Can you explain through an example?
User 11/06/2018 - 01:48
Can you see the document preview?
Excelchat Expert 11/06/2018 - 01:48
User 11/06/2018 - 01:49
Notice how they are all ace?
Excelchat Expert 11/06/2018 - 01:49
User 11/06/2018 - 01:49
but they all indicate that they're ace with a different textual input
User 11/06/2018 - 01:50
imagine I have a list of 12,000 cells. With various cells that have information similar to the ace example.
User 11/06/2018 - 01:51
I want to find a way that I could easily point out that there are similarities within the huge list that I need to look more closely at
Excelchat Expert 11/06/2018 - 01:51
Do you want to seperate Ace and the next word?
Excelchat Expert 11/06/2018 - 01:51
would that help?
Excelchat Expert 11/06/2018 - 01:53
Do you see column C, and D
Excelchat Expert 11/06/2018 - 01:53
Would that help?
Excelchat Expert 11/06/2018 - 01:54
i need to know what exactly you want..how you want to use the data so that i can help you with the exact requirement
User 11/06/2018 - 01:55
thanks that helps
Excelchat Expert 11/06/2018 - 01:55
Excelchat Expert 11/06/2018 - 01:55
Please do give good rating and review
Excelchat Expert 11/06/2018 - 01:55
It would certainly help a lot
Excelchat Expert 11/06/2018 - 01:55
Have a great day

This is the output file from the real Excelchat help session:
This is an example of the expert help you can get. It contains no private user information.

Get instant expert help with Excel and Google Sheets

Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Your privacy is guaranteed. Your session will not be used for blog unless you give us persmission.

Click here to get your free Excelchat help session

Subscribe to Excelchat.co
Trusted by people who work at
Amazon.com, Inc
Facebook, Inc
Accenture PLC
Siemens AG
The Allstate Corporation
United Parcel Service
Dell Inc