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