Text Colour Within Formula

[Guest]

Hi there


I have a formula that says

="Sales Figures from "&D2&" up to the end of "&E2

D2 & E2 are the names of months taken from dates in other cells.

I cannot seem to find a way to get the month texts to be in a different
colour from the rest of the text that is returned. I note from other
conversations here that Excel can only take values from one cell to another
in a formula, not formatting aswell. When i highlight the cell refs in the
formula, the formatting buttons for text colour are greyed out.


Is there any way to do this?


Many thanks


jb

 

[Guest]

Copy the cell containing the formula and paste/special as value elsewhere in
the worksheet. The new cell can be formatted as you wish since it is text
rather than a formula.

 

[Guest]

Hi


thanks for that. While that would work as a one off, i need the cell to
remain responsive to changes in the date cells that feed the main formula.
Are there any other ways that you know?


cheers


jb

 

[Dave Peterson]

Maybe you could use 4 cells:

Sales Figures from: 2006
Up to the end of: March

And format each the way you want.

 

[Guest]

Not to my knowledge. Consider a very simple example:
put 2 in A1
put 10 in A2
put =A1+A2 in A3
12 will appear in A3

I don't know any way to get the different digits in twelve to appear in
different colours if the twelve results from a formula.