Format numbers returned in the function CONCATENATE
 

I would like to format the numbers that are returned in the function below as
[Blue]$#,##0.00_);[Red]($#,##0.00)
so that the result shows:

147,852.36 needed to break the weekly record of 654,987.32.

NOTE: Positive numbers are blue and negative numbers are red, with the comma
as the thousand separator, two decimal places, and in parenthesis.

FUNCTION IN CELL
=CONCATENATE(SUM(K20-D12)," needed to break the weekly record of ",K20)

I tried this:

=CONCATENATE(TEXT(J26,"[Blue]$#,##0.00_);[Red]($#,##0.00)")&"the quick brown
fox jumps over the dog. "&(SUM(K20-D12)))

But it did not work.

Is it possible?

Format numbers returned in the function CONCATENATE
 

you can't format numbers inside a formula with colors based on their values.

"Kip" wrote in message
...
I would like to format the numbers that are returned in the function below
as
[Blue]$#,##0.00_);[Red]($#,##0.00)
so that the result shows:

147,852.36 needed to break the weekly record of 654,987.32.

NOTE: Positive numbers are blue and negative numbers are red, with the
comma
as the thousand separator, two decimal places, and in parenthesis.

FUNCTION IN CELL
=CONCATENATE(SUM(K20-D12)," needed to break the weekly record of ",K20)

I tried this:

=CONCATENATE(TEXT(J26,"[Blue]$#,##0.00_);[Red]($#,##0.00)")&"the quick
brown
fox jumps over the dog. "&(SUM(K20-D12)))

But it did not work.

Is it possible?

Format numbers returned in the function CONCATENATE
 

Thanks for the reply Bob.

Can I format the numbers without color?

"Bob Umlas" wrote:

you can't format numbers inside a formula with colors based on their values.

"Kip" wrote in message
...
I would like to format the numbers that are returned in the function below
as
[Blue]$#,##0.00_);[Red]($#,##0.00)
so that the result shows:

147,852.36 needed to break the weekly record of 654,987.32.

NOTE: Positive numbers are blue and negative numbers are red, with the
comma
as the thousand separator, two decimal places, and in parenthesis.

FUNCTION IN CELL
=CONCATENATE(SUM(K20-D12)," needed to break the weekly record of ",K20)

I tried this:

=CONCATENATE(TEXT(J26,"[Blue]$#,##0.00_);[Red]($#,##0.00)")&"the quick
brown
fox jumps over the dog. "&(SUM(K20-D12)))

But it did not work.

Is it possible?

Format numbers returned in the function CONCATENATE
 

Figured it out. The function below returns:

$149,550.15 is needed to break the weekly record of $878,784.15

=CONCATENATE(TEXT(SUM(K20-D12),"$#,##0.00_);($#,##0.00)")&"is needed to
break the weekly record of "&(TEXT(SUM(K20),"$#,##0.00_);( $#,##0.00)")))
====================
"Bob Umlas" wrote:

you can't format numbers inside a formula with colors based on their values.
====================
"Kip" wrote in message
...
I would like to format the numbers that are returned in the function below as
[Blue]$#,##0.00_);[Red]($#,##0.00)
so that the result shows:

147,852.36 needed to break the weekly record of 654,987.32.

NOTE: Positive numbers are blue and negative numbers are red, with the comma
as the thousand separator, two decimal places, and in parenthesis.

FUNCTION IN CELL
=CONCATENATE(SUM(K20-D12)," needed to break the weekly record of ",K20)

I tried this:

=CONCATENATE(TEXT(J26,"[Blue]$#,##0.00_);[Red]($#,##0.00)")&"the quick brown
fox jumps over the dog. "&(SUM(K20-D12)))

But it did not work.

Is it possible?