Change partial text color, up to specific character (loop)

[xtinct2]

Hi --

I would like to apply a code that changes the first characters of a cell up-to (& including) the "/" character. I would like for this partial string to be formatted to the simple 'red' color.

For instance, in "hello world / how are you?" I would like for it to color "hello world /" in red. The remaining text should remain as is.

I would then like for it to loop this same function for every row, until it hits a blank cell.

Could you please assist?

Thank you,
k

[kvsrinivasamurthy]

Range is A2:A7. change as required.

Please Login or Register  to view this content.

[xtinct2]

Thank you --

I took your Cel.Characters(Start:=1, Length:=K).Font.Color = -16776961 line and played w/ the peripherals to make the loop dynamic for any range size