&TEXT formula

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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%")
 
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
format>conditional formatting
 
Peo Sjoblom said:
No need for those extra TEXT parts

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

No need for most of those text constants.

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Move text 1
Difficult Formula 9
Simplify this formula 8
If Formula 10
Searching the formula (not the value) for a text string 1
Minimum without zeros or negatives 3
Lookup Function 1
Excel Change Excel Text colour from Formula Bar 0

Back
Top