Numeric Formula font color change
I have a Numeric Formula. It is a simple subtraction field. [Total Points 2015-16]-[Total Points 2016-2017] I would like to have it turn green when positive, and red when negative. I understand y...
Forum Discussion
Try this
// enter your field name here:
var number Rounded = Round([My Points Subtraction field]);
var text MyNumberInText = ToText($Rounded);
var text ColorCode =
If(
$Rounded < 0,"pink", "green");
Case($ColorCode,
"pink","<div style=\"background-color: pink;\"" & ">" & $MyNumberInText & "</div>",
"green","<div style=\"background-color: #00C957;\"" & ">" & $MyNumberInText & "</div>")
// enter your field name here:
var number Rounded = Round([My Points Subtraction field]);
var text MyNumberInText = ToText($Rounded);
var text ColorCode =
If(
$Rounded < 0,"pink", "green");
Case($ColorCode,
"pink","<div style=\"background-color: pink;\"" & ">" & $MyNumberInText & "</div>",
"green","<div style=\"background-color: #00C957;\"" & ">" & $MyNumberInText & "</div>")