Forum Discussion
ArchiveUser
9 years agoQrew Captain
Ok, here are the two options I came up with.
For coloring the Font Only:
var text tnum = ToText(Int(Abs([Numeric]))) & "." &Right(ToText(Frac(Abs([Numeric]))*100+100),2);
If([Numeric]<0,"<div style=\"color:red;\">"&"$ "& $tnum&"</div>",
[Numeric]=0,"<div style=\"color:black;\">"&"$ "&$tnum&"</div>",
[Numeric]>0,"<div style=\"color:#3EC41C;\">"&"$ "&$tnum&"</div>")
For coloring the Background & making the Font white:
var text tnum = ToText(Int(Abs([Numeric]))) & "." &Right(ToText(Frac(Abs([Numeric]))*100+100),2);
If([Numeric]<0,"<div style=\"background-color:red;color:white;\">"&"$ "& $tnum&"</div>",
[Numeric]=0,"<div style=\"background-color:black;color:white;\">"&"$ "&$tnum&"</div>",
[Numeric]>0,"<div style=\"background-color:#3EC41C;color:white;\">"&"$ "&$tnum&"</div>")
For coloring the Font Only:
var text tnum = ToText(Int(Abs([Numeric]))) & "." &Right(ToText(Frac(Abs([Numeric]))*100+100),2);
If([Numeric]<0,"<div style=\"color:red;\">"&"$ "& $tnum&"</div>",
[Numeric]=0,"<div style=\"color:black;\">"&"$ "&$tnum&"</div>",
[Numeric]>0,"<div style=\"color:#3EC41C;\">"&"$ "&$tnum&"</div>")
For coloring the Background & making the Font white:
var text tnum = ToText(Int(Abs([Numeric]))) & "." &Right(ToText(Frac(Abs([Numeric]))*100+100),2);
If([Numeric]<0,"<div style=\"background-color:red;color:white;\">"&"$ "& $tnum&"</div>",
[Numeric]=0,"<div style=\"background-color:black;color:white;\">"&"$ "&$tnum&"</div>",
[Numeric]>0,"<div style=\"background-color:#3EC41C;color:white;\">"&"$ "&$tnum&"</div>")