Custom Text Format

[Sakurkar]

Dear friends,
I have three names of planet in one cell. i. e. Sun, Moon, Mars in one cell. I want Mars formatted in red colour.
Can any one help me please.
Thanks.

 

[kanadaaa]

Sun, Moon, Mars all are in one cell and I want Mars in Red colour.

I missed the part "in one cell". Sorry this is why custom format didn't work.
As others say, you need VBA and the code in #9 works well.

 

[Joe4]

Extremely sorry sir, it`s my mistake.

No worries. You just want to wait until you have a working solution before you mark it as a solution.
I have unmarked it for you.

 

[Sakurkar]

It's not your mistake & you did nothing wrong.
You can't custom format part of a cell. It would need VBA

I missed the part "in one cell". Sorry this is why custom format didn't work.
As others say, you need VBA and the code in #9 works well.

Thanks

 

[Sakurkar]

It's not your mistake & you did nothing wrong.
You can't custom format part of a cell. It would need VBA

ok sir.

 

[Fluff]

Have you tried the code from post#9?