Is there any way to change the color and/or font of specific text within an excel cell? That is, I'd like one part of the cell's displayed value to be red and another part of the same cell's displayed value to be blue (as an example). Since the displayed values are being calculated as formulas, I'd need some sort of formatting formula that would apply only the stuff inside the formula. I can't seem to find anything in the text.
Oops! Missed the part about it being a calculated value. Conditional formatting is the way to go.
Mick Sharpe
2010-01-21 14:14:30
+1
A:
If you want to do this based on a formula, you will have to write some VBA. See this example
Maurits Rijk
2010-01-21 14:07:27
Yes. You can change any attribute. Font name and type, bold, strikethrough, etc. etc. this way. There are many VBA examples available on how to do this.
Maurits Rijk
2010-01-23 10:25:13
I can't use conditional formatting because I want the fonts/colors to apply to specific calculated values within the cell. I am creating an inline bar graph. I'd like to format the bar graph using one font and the associated value using a different font.
jhc
2010-01-21 20:13:04