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

"Gary''s Student" wrote:

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.
--
Gary's Student


"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