scan text in cell and color part of the text

M

mrom34

Joined
Apr 29, 2010
Messages
1
Reaction score
0
Hi,

I need to create a listing for my customer and they want something a little complex for me.
Basically, I need to check the cells in a file and color in blue some text.
For example, if I have a cell with:
*apple, peach, *banana

I need to color in blue *apple and *banana (because they start with *) but peach should remain black.
I know how to program a macor to color the cell if a specific charatec exist, but I don't really know how to color only a part of the text.

Do you have any recommandations?

Thanks in advance

Romain
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Autofill cells in 1 column :code ?? 2
Need help in using INDIRECT, SUBSTITUTE, and OR in a formula fordependent dropdown list 2
counif by column2 & column 4 ? 3
How to dynamically change the list in drop down list based on thevalue of another cell? 1
Selecting all cells in a column between two cells 12
delete duplicate data in the same cell 6
Excel Macro to automatically go to the right of the last colored cell 0
Lookup and match color of corresponding cell 4

Top