LinkBack URL
About LinkBacks
hey folks,
i have 2 columns of data. column A has surnames and column B has first and second names. i need to be able to highlight the names in column B that have surnames in column A. any ideas?
hey folks,
i have 2 columns of data. column A has surnames and column B has first and second names. i need to be able to highlight the names in column B that have surnames in column A. any ideas?
Select range of names in column B.
Go to Format|Conditional Formatting and select Formula Is from 1st drop down...
enter formula: =OR(ISNUMBER(SEARCH($A$1:$A$4,$B1)))
where A1:A4 is list of surnames in column A, and B1 is top-most cell in your selected range.
adjust to suit.
Click format and choose your colour from pattern tab.
Click Ok. Click Ok again to finish.
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.
great. thanks for that
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks