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