Highlight Text within bracket to Red

[PSG]

Hello All,

I need your help to create / Find any code which can turn any text / Number within bracket to Red.

Ex.

I have emails copied to (Turn me Red): Email Owners (Turn me Red) Name
Excel - Move (Turn me Red) Data In A Cell (Turn me Red) To Another Cell
Remove Text With (Turn me Red) Brackets & The Parenthesis
How to extract text between (Turn me Red) commas/brackets/parentheses

There can be multiple instances of this in a single line.

Thank You

 

[Faseeh]

Hi PSG,

Please see attachment

Source: http://superuser.com/questions/321131/color-text-content-contained-within-brackets

 

[PSG]

Hello Faseeh,

Thank you for your prompt response. But this is useful only when I am manually adding text and brackets in a cell. My problem is I am copy pasting information from multiples sheet to a summary tab. Where I want to highlight text / number within bracket.

I hope I am making myself clear and causing no confusion.

 

[Faseeh]

Hi PSG,

I just tried on sheet 2, even if you copy from it and paste on sheet1 it is working. can you verify it?

 

[PSG]

Hello Faseesh,

Not working here. Run time error coming at

Text = Target.Text

Let me know if you have an alternative method or code

 

[Faseeh]

can you post the sample file giving error.

 

[PSG]

Hello Faseeh,

I think, I got it.

Sub test()

    Dim Text As String
    Dim Index1 As Long
    Dim Index2 As Long
    Dim i As Integer
  
  
    For i = 1 To 100
    Text = Cells(i, 3).Text
    Index2 = 1
    Do
        Index1 = InStr(Index2, Text, "(")
        If Index1 = 0 Then Exit Do
        Index2 = InStr(Index1, Text, ")")
        If Index2 = 0 Then Exit Do
        Cells(i, 3).Characters(Index1 + 1, Index2 - Index1 - 1).Font.Color = &HFF
    Loop
    Next i
End Sub

Thank you for the help