Forum Discussion
letter by letter comparison
I think I've done.. I hope so anyway.
Hi Mahmoud,
I've updated the file with the solution.
It now has two sheets, the first to hide the letters, and the second to change its font color.
You will find some helper cells on the right side of each sheet, you must keep these cells, if they annoy you, you can hide their column
If you want to test a new text, you should first type it into the Full Text cell, and then test it in cell B1.
Hope that helps
Dear Haytham,
There is a bug there, you see if I wrote any letters that are NOT in the column (which will happen all the time), then excel will mistakingly delete or change color of the first letters as if it is identical, while it is not.
Please find the attached.
Thank you ...
Dear Mahmoud,
Sorry, but I said in the previous reply that you should first type it into the Full Text cell, and then test it in cell B1.
Dear Haytham,
Thank you, but it is the same.
If I put the fixed text in the (Full-Text Cell), it goes to the column, that is great ... then when I start comparing with the other text, which is actually not identical, that is the purpose of the comparison, what happens is that we get an empty cell each time we enter a non-identical letter, which is exactly the opposite of the demand, we need it to disappear when there is a match.
The two texts are not identical, the purpose of the comparison is to see how many letters are missing or extra.
Thank you a lot ... and yours
