Hello everybody,
I tried to find anything similar that would solve this problem. I have two columns that would highlight words that match and then in column C to give me the count how many matched. For example in the first line there is only one match and word "Car" should be highlighted. In the second line there are 2 matches "Cars" and "Great" which should also be highlighted and so on. This should not be case sensitive, so "Great" and "great" should be the match. I tried so many similar macros that highlight the whole cell instead of just keyword inside each cell. I am comparing Column A with Column B so all highlights should be placed in Column B. I prefer this to be in VBA but if there is any other solution I am open to that. I appreciate any help on this issue. Thanks.
I tried to find anything similar that would solve this problem. I have two columns that would highlight words that match and then in column C to give me the count how many matched. For example in the first line there is only one match and word "Car" should be highlighted. In the second line there are 2 matches "Cars" and "Great" which should also be highlighted and so on. This should not be case sensitive, so "Great" and "great" should be the match. I tried so many similar macros that highlight the whole cell instead of just keyword inside each cell. I am comparing Column A with Column B so all highlights should be placed in Column B. I prefer this to be in VBA but if there is any other solution I am open to that. I appreciate any help on this issue. Thanks.
| Compare1 | Compare2 | Count Matched Words |
| Driving Car | Car is so useful | 1 |
| Cars are great | Great that we have cars today | 2 |
| Mazda is reliable car | Mazda is good car | 3 |
| Walking is good for your health | Health is precious | 2 |
| Library is so far away | I live so far away | 3 |
