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?