Hi all.
I use the following code to highlight in red, certain keywords which appear in a sheet.
There are many more, but I have just shortened it for this purpose.
It works well, but it will highlight anything which contains the word e.g. TEA
Like STEAM MOP.
Or BOOKCASE and not just BOOK
Is there a way to just highlight the specific word I have in the Comments
Thanks for looking
Please Login or Register to view this content.
Regards,
Graham
Please ignore.
Last edited by Mumps1; 10-02-2022 at 11:03 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.
Hi
I tried that but it does not flag up, as the text on the sheet does not have a space after it.
Try:
Please Login or Register to view this content.
Administrative Note:
We would very much like to help you with your query, however it has been brought to our attention that the same query has been posted on one or more other forums and you have not told us about this. You are required to do so.
Please see Forum Rule #3 about cross-posting and adjust accordingly. Read this to understand why we (and other sites like us) consider this to be important: https://excelguru.ca/a-message-to-forum-cross-posters/
(Note: this requirement is not optional. No help to be offered until you provide a link or, for members with fewer than 10 posts, a comment telling us where else you have posted this query.)
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Sorry, I was not aware about cross posting
Here is the link to the other post
https://www.mrexcel.com/board/thread.../#post-5955526
Thanks Mumps1
It seems to take forever to run.
I stopped it after a few mins.
Is there a way to quicken it up.
See if this is works,
Please Login or Register to view this content.
Hi Jindon.
This works great and is a lot faster than the one I had originally.
Just one more question
Is there a way to highlight the cell in green as well as the text being red.
Regards,
Graham
Do you mean?
Please Login or Register to view this content.
Hi Jindon.
No, I want the cell to be filled with green and the specific text in Red
Then adjust the bold lines
Please Login or Register to view this content.
Hi Jindon.
This is perfect.
Thanks for all your help.
Regards,
Graham
You are welcome and thanks for the rep.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks