Re: Formula: Color Coding and Dates

Just want to colour a single field it's a little more complicated than XL. You're actually need to create a formula rich text field and use a formula as described here.  

https://help.quickbase.com/user-assistance/color-coding_fields.html

Here is another example

Background Shading
var text ColorCode =

If(

[Delivery Date]-Today()<Days(1),"pink",

[Delivery Date]-Today()<Days(3),"yellow",

[Delivery Date]-Today()<Days(5),"green");

var text DateText = ToText([Delivery Date]);

Case($ColorCode,

"pink","<div style=\"background-color: pink;\"" & ">" & $DateText & "</div>",

"yellow","<div style=\"background-color: yellow;\"" & ">" & $DateText & "</div>",

"green","<div style=\"background-color: #00C957;\"" & ">" & $DateText & "</div>", $DateText)



------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------