Partial Formatting

It cannot be done with CF, but it is possible as long the values are hard values & not a formula.

Do you just want to look for the & sign and what cells should this work on?

Thanks for getting back.

Yes , all the values are hard text values. In my own case here the best character to look for would be a dot (.) in each of the cells H5:H300.

I'd be looking to colour the first dot and everything after it white if possible please.

Ok, how about

Sub CDandVinyl()
   Dim Cl As Range
   Dim i As Long
   
   For Each Cl In Range("H5:H300")
      i = InStr(1, Cl.Value, ".")
      If i > 0 Then Cl.Characters(i, Len(Cl.Value)).Font.Color = vbWhite
   Next Cl
End Sub

OK That's perfect. Thanks. It worked first time.

Problem solved!

You're welcome & thanks for the feedback