Highlighting single Text in excel sheet by macro

Hi, I would like to highlight particular TEXT in the cell to be in BOLD and in Color.

Please let me know , how can i get this by Macro.


Regards,
NM

hi NM123
Welcome to the forum..
you can adapt something like....

Please Login or Register  to view this content.

Hi PIke,
Thanks for the warm welcome !!!

The code provided by you is not working. Probably i would like to explain more on my requirements, so that you will have an idea on it.

My requirement is, I have two specific words "Now :" and "Was :" in the sheet, which explains about the two versions changes.I want to highlight those two words in the excel sheet which will be clearly visible. I would like to share the code which i used for comparion of 2 version of sheets.

Please Login or Register  to view this content.

I hope this clears you my requirements.

Regards,
NM

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the # at the top of your post window. For more information about these and other tags, found here

Hi NM123,
Dont think in can be done in 2003 but this works in 2010

Please Login or Register  to view this content.

This has taken me months of work and a lot of input from forum members. You can find the latest working version here.

If you have any questions, let me know.

abousetta

hI NM123,
Your welcome
Just start a new thread for each new question.....

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

Nice work abousetta

Thanks Pike. The real credit goes to everyone here at the forum who helped me put this together. Off the top of my head, shg, romperstomper and mikerickerson were vital in different parts of the code... Hats off to them.

abousetta