Sep 30 2022 08:39 AM
I have data in cells A1 and B1. In C1, there is a formula concatenating together A1 and B1. I want the portion of C1 that comes from A1 to be a different color from the part coming from B1. Can I do this?
Sep 30 2022 09:21 AM
This should be possible with the Range.Characters property in VBA like this:
.Range("C" & i).Characters(1, lengthA1).Font.Color = vbBlue
Sep 30 2022 09:25 AM
But that won't work if the cells in column C contain formulas.