Forum Discussion
Formatting part of a cell containing formula
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?
2 Replies
This should be possible with the Range.Characters property in VBA like this:
.Range("C" & i).Characters(1, lengthA1).Font.Color = vbBlue
But that won't work if the cells in column C contain formulas.
