Forum Discussion
QuickBaseCoachD
8 years agoQrew Captain
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>")