Partial font color

[Isaacadete]

Hi dear
All can I have a partial font color within this range?
It allows only fully font color change, like the whole cell, but not only a few words of the cell.

Can that be modified?

Please Login or Register  to view this content.

[davesexcel]

Your code doesn't mention anything about .Font.Color

[Isaacadete]

yes it doesn't...
but i can't do partial font color changing on that range.
I have my code here, to see if it can be added anything.

[davesexcel]

If you want to color a word in a cell you need to find the word first

12-9-2015 4-57-55 AM.jpg

Then run the code and change the word "There" to red font.

12-9-2015 4-59-10 AM.jpg

Please Login or Register  to view this content.