Color/Highlight the Partial Content of a Cell

[K.Raja]

Hai,

There is content in a cell about 10 words. But I wanted to color only one or two words.

This should be done for around 1000 cells, hence I would request you to provide a macro for coloring words from a cell in one shot.



Regards,
Raja

[HaHoBe]

Hi, K.Raja,

AFAIK this may only be done by stepping through the characters of the cells and colouring those that meet the cirteria. So it would be good if you could pass some more information as to what you mean by

But I wanted to color only one or two words

On one sheet? In one Workbook? Will the words be listed on a different sheet? Shall only those words be coloured? The same colour for each word? If the words change shall the colour of the other words be reverted back to black?

Ciao,
Holger

[xlbiznes]

Try this code to highlight words with specific colors.

[K.Raja]

Thank you..........

Its working........

[xlbiznes]

You are welcome, Please mark this thread as closed if you are satisfied with the solution provided.