software

Hi thereI have a formula that says

=quot;Sales Figures from quot;amp;D2amp;quot; up to the end of quot;amp;E2

D2 amp; 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 thanksjb

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 Studentquot;JB2010quot; wrote:

gt; Hi there
gt;
gt;
gt; I have a formula that says
gt;
gt; =quot;Sales Figures from quot;amp;D2amp;quot; up to the end of quot;amp;E2
gt;
gt; D2 amp; E2 are the names of months taken from dates in other cells.
gt;
gt; I cannot seem to find a way to get the month texts to be in a different
gt; colour from the rest of the text that is returned. I note from other
gt; conversations here that Excel can only take values from one cell to another
gt; in a formula, not formatting aswell. When i highlight the cell refs in the
gt; formula, the formatting buttons for text colour are greyed out.
gt;
gt;
gt; Is there any way to do this?
gt;
gt;
gt; Many thanks
gt;
gt;
gt; jb

Hithanks 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?cheersjb

quot;Gary''s Studentquot; wrote:

gt; Copy the cell containing the formula and paste/special as value elsewhere in
gt; the worksheet. The new cell can be formatted as you wish since it is text
gt; rather than a formula.
gt; --
gt; Gary's Student
gt;
gt;
gt; quot;JB2010quot; wrote:
gt;
gt; gt; Hi there
gt; gt;
gt; gt;
gt; gt; I have a formula that says
gt; gt;
gt; gt; =quot;Sales Figures from quot;amp;D2amp;quot; up to the end of quot;amp;E2
gt; gt;
gt; gt; D2 amp; E2 are the names of months taken from dates in other cells.
gt; gt;
gt; gt; I cannot seem to find a way to get the month texts to be in a different
gt; gt; colour from the rest of the text that is returned. I note from other
gt; gt; conversations here that Excel can only take values from one cell to another
gt; gt; in a formula, not formatting aswell. When i highlight the cell refs in the
gt; gt; formula, the formatting buttons for text colour are greyed out.
gt; gt;
gt; gt;
gt; gt; Is there any way to do this?
gt; gt;
gt; gt;
gt; gt; Many thanks
gt; gt;
gt; gt;
gt; gt; 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:
gt;
gt; Hi there
gt;
gt; I have a formula that says
gt;
gt; =quot;Sales Figures from quot;amp;D2amp;quot; up to the end of quot;amp;E2
gt;
gt; D2 amp; E2 are the names of months taken from dates in other cells.
gt;
gt; I cannot seem to find a way to get the month texts to be in a different
gt; colour from the rest of the text that is returned. I note from other
gt; conversations here that Excel can only take values from one cell to another
gt; in a formula, not formatting aswell. When i highlight the cell refs in the
gt; formula, the formatting buttons for text colour are greyed out.
gt;
gt; Is there any way to do this?
gt;
gt; Many thanks
gt;
gt; 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 Studentquot;JB2010quot; wrote:

gt; Hi
gt;
gt;
gt; thanks for that. While that would work as a one off, i need the cell to
gt; remain responsive to changes in the date cells that feed the main formula.
gt; Are there any other ways that you know?
gt;
gt;
gt; cheers
gt;
gt;
gt; jb
gt;
gt; quot;Gary''s Studentquot; wrote:
gt;
gt; gt; Copy the cell containing the formula and paste/special as value elsewhere in
gt; gt; the worksheet. The new cell can be formatted as you wish since it is text
gt; gt; rather than a formula.
gt; gt; --
gt; gt; Gary's Student
gt; gt;
gt; gt;
gt; gt; quot;JB2010quot; wrote:
gt; gt;
gt; gt; gt; Hi there
gt; gt; gt;
gt; gt; gt;
gt; gt; gt; I have a formula that says
gt; gt; gt;
gt; gt; gt; =quot;Sales Figures from quot;amp;D2amp;quot; up to the end of quot;amp;E2
gt; gt; gt;
gt; gt; gt; D2 amp; E2 are the names of months taken from dates in other cells.
gt; gt; gt;
gt; gt; gt; I cannot seem to find a way to get the month texts to be in a different
gt; gt; gt; colour from the rest of the text that is returned. I note from other
gt; gt; gt; conversations here that Excel can only take values from one cell to another
gt; gt; gt; in a formula, not formatting aswell. When i highlight the cell refs in the
gt; gt; gt; formula, the formatting buttons for text colour are greyed out.
gt; gt; gt;
gt; gt; gt;
gt; gt; gt; Is there any way to do this?
gt; gt; gt;
gt; gt; gt;
gt; gt; gt; Many thanks
gt; gt; gt;
gt; gt; gt;
gt; gt; gt; jb