How to change the word from blue to red, e.g.:
It is a pen.
to
It is a pen.
(same for all cells that are blue)
How to change the word from blue to red, e.g.:
It is a pen.
to
It is a pen.
(same for all cells that are blue)
hi london7871, seems like you'll need vba to perform that.
could you clarify further whether word in blue font is for entire cell or part of a cell?
1. Click on the * Add Reputation if you think someone helped you
2. Mark your thread as SOLVED when question is resolved
Alvin
london, if that is all in the same cell, you cannot fdo that with any formula or even Conditional Formatting, you will need VBA (code) for that
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
London, please do not post duplicate threads. I see you have another thread on this here...
https://www.excelforum.com/excel-pro...ific-word.html
I would merge them for you, but there seems to be an issue with that at the moment, so I will close this 1, please continue on the other 1
Thanks
Thread closed
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks