Highlight matching parts of a string
I have two cells containing comma seperate strings of text. I would like to compare them and highlight any matches in the string.
Eg
A1= a, b, c, d, e
A2= a, f, e, g, h.
The list are in no particular order or length and can contain any number of values. all seperated by comma space.
Last edited by ianh; 11-22-2010 at 11:21 AM.
You cannot conditionally format a part of a cell entry.
If you separate each entry into individual cells, then you can highlight cells.
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
You can format parts of a cells text, I have been using the following code to highlight parts that dont matchRun by the following macro
Please Login or Register to view this content.
I need to be able to carry out the inverse of this and highlight the matches but cant get the code to work that way.Please Login or Register to view this content.
I guess I assumed you were looking for conditional formatting via native Excel functions...
Simple version:
Please Login or Register to view this content.
Remember what the dormouse said
Feed your head
Please Login or Register to view this content.
Last edited by snb; 11-22-2010 at 09:49 AM.
That great, thanks for your help
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save
I'm trying to scale this up to suit the work book but for some reason it doesn't always highlight all of the matching values. I'm not sure why not.
It's now working with the live data, not sure what happened in between, many thanks agin for both methods
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks