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