Hi all,
I have no idea how to write a macro and hope someone can help with the followign.
I have a list of words in cell A1 example:
test, tested, participant, new, help, helper
and I have lots of comments in cell B1 to B1000. How do I write a macro/way of highlighting words in red font in cell B1 to B1000 which are from Cell A1? Any help appreciated. thank you!!
Thanks,
R.
a quick and simple nonMacro solution is to put your data in a Table and Filter it. in the filtered column you can put things like "Test*" or "*test*" which will do the same thing as a macro. Once your results are displayed, you can color as you like.
Give this ode a try:
Please Login or Register to view this content.
Try:
Please Login or Register to view this content.
Last edited by Mumps1; 01-13-2021 at 09:00 AM.
You can say "THANK YOU" for help received by clicking the Star symbol at the bottom left of the helper's post.
Practice makes perfect. I'm very far from perfect so I'm still practising.
Try
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks