Forum Discussion

CeceliaMartin's avatar
CeceliaMartin
Qrew Cadet
7 years ago

Formula to show status for inbtween number range

I would like to have a yellow status for anything between 98 & 93 If([On Time Shipping]<99,"<img src=\"https://www.quickbase.com/up/bcgnn27bx/g/rdd/eh/va/222-point_green.png\">";, If([On Time Ship...
DavidBrogdon's avatar
DavidBrogdon
Qrew Assistant Captain
7 years ago
Try this -->

If([On Time Shipping]<99,"<span style='font-size: 15pt; text-align: left; color: green'>" & ToText([On Time Shipping]) & "</span>",

[On Time Shipping]>92,<span style='font-size: 15pt; text-align: left; color: red'>" & ToText([On Time Shipping]) & "</span>",

[On Time Shipping]>=98 & <=93,<span style='font-size: 15pt; text-align: left; color: yellow'>" & ToText([On Time Shipping]) & "</span>" )