Forum Discussion

IanIan's avatar
IanIan
Qrew Member
9 years ago

Conditionally change color of formula numeric field, either text or background, without using a a Formula Text field.

I want to change either the background or text of a formula numeric field based on conditions (e.g. over budget). I have made it work using a formula text field that mimics the number, and even got a ...
Formulas and functions
reports and charts
Tables and fields
ArchiveUser's avatar
ArchiveUser
Qrew Captain
9 years ago
If([Labor Budget Balance Original]<0,"<div style=\"color:red;\">"&"$"&ToFormattedText(Round([Labor Budget Balance Original],0.01),"comma_dot")&"</div>",

[Labor Budget Balance Original]=0,"<div style=\"color:black;\">"&"$"&ToFormattedText(Round([Labor Budget Balance Original],0.01),"comma_dot")&"</div>",

[Labor Budget Balance Original]>0,"<div style=\"color:#3EC41C;\">"&"$"&ToFormattedText(Round([Labor Budget Balance Original],0.01),"comma_dot")&"</div>")