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]

Set the conditional formatting as:
Format only cells that contain > cell value, equal to, "Mars"
Then choose red in the color section of the format tab.

 

[Sakurkar]

Set the conditional formatting as:
Format only cells that contain > cell value, equal to, "Mars"
Then choose red in the color section of the format tab.

Dear Kanadaaa,
Thank you very much for your quick reply,
I have done as told by you but unfortunately it is not working.
thanks once again,
Sakurkar, India.

 

[kanadaaa]

Dear Kanadaaa,
Thank you very much for your quick reply,
I have done as told by you but unfortunately it is not working.
thanks once again,
Sakurkar, India.

You must have done it wrong because it should never happen if you've done it right.
Tell me in detail what you did.

 

[Joe4]

I have done as told by you but unfortunately it is not working.

If it didn't work, why did you mark it as the solution?

 

[kanadaaa]

Dear Kanadaaa,
Thank you very much for your quick reply,
I have done as told by you but unfortunately it is not working.
thanks once again,
Sakurkar, India.

Ok I think I get it, you must have input Mars with double quotation marks in the conditional formatting setting.

 

[Sakurkar]

Ok I think I get it, you must have input Mars with double quotation marks in the conditional formatting setting.

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

 

[Sakurkar]

If it didn't work, why did you mark it as the solution?

Extremely sorry sir, it`s my mistake.

 

[aRandomHelper]

Try this VBA solution:

Sub me1160394_colorWord()
    Dim c As Range, w
    
    w = "Mars" 'edit to look for something else
    
    For Each c In Selection
        If InStr(c.Text, w) > 0 Then
            c.Characters(InStr(c.Text, w), Len(w)).Font.Color = vbRed
        End If
    Next
End Sub

Select the cell(s) (can be more than one) containing the words and run this macro. The first occurrence of "Mars" (you can edit this text) will be highlighted in red (replace vbRed with something else if you want a different color).

 

[Fluff]

Extremely sorry sir, it`s my mistake.

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