&TEXT formula
 

I have and & TEXT formula that makes a statement like:

Month: 5.1 Chg YTD -2.5

In the &TEXT formula, how do I format the numbers so that all negative
value's will show in red. Below is my formula:
=B5&TEXT(" ",0)&TEXT(C5,"0.0")&TEXT(" ",0)&E5&TEXT("
",0)&TEXT(F5,"0.0%")

&TEXT formula
 

No need for those extra TEXT parts

=B5&" "&TEXT(C5,"0.0")&" "&E5&" "&TEXT(F5,"0.0%")

However you cannot change part of the formula to red, you can change the
whole formula result to red based on any of the values by using
formatconditional formatting



--
Regards,

Peo Sjoblom



"lrcburgers" wrote in message
...
I have and & TEXT formula that makes a statement like:

Month: 5.1 Chg YTD -2.5

In the &TEXT formula, how do I format the numbers so that all negative
value's will show in red. Below is my formula:
=B5&TEXT(" ",0)&TEXT(C5,"0.0")&TEXT(" ",0)&E5&TEXT("
",0)&TEXT(F5,"0.0%")

&TEXT formula
 

"Peo Sjoblom" wrote...
No need for those extra TEXT parts

=B5&" "&TEXT(C5,"0.0")&" "&E5&" "&TEXT(F5,"0.0%")
....

No need for most of those text constants.

=B5&TEXT(C5," 0.0")&" "&E5&TEXT(F5," 0.0%")

&TEXT formula
 

or even:
=B5&TEXT(C5," 0.0 ")&E5&TEXT(F5," 0.0%")


Harlan Grove wrote:

"Peo Sjoblom" wrote...
No need for those extra TEXT parts

=B5&" "&TEXT(C5,"0.0")&" "&E5&" "&TEXT(F5,"0.0%")
...

No need for most of those text constants.

=B5&TEXT(C5," 0.0")&" "&E5&TEXT(F5," 0.0%")

--

Dave Peterson