Maybe you could use 4 cells:

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

And format each the way you want.

JB2010 wrote:

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

--

Dave Peterson