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

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

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

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

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


"JB2010" wrote:

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