I have a formula-duration field and i want to change the font color when the days are negative eg. -20days *to show that its delayed* what formula should i use?

22 Points

Posted 3 years ago

QuickBaseCoach App Dev./Training, Champion

59,768 Points

Unlike Excel there is no concept of Conditional formatting of a cell. So, you would need make a second field which is a Text formula and use that one when displaying on forms and reports.

Not tested, but try this

IF([My duration formula field]<Days(0),"<font color=red><b>")

& ToText([My duration formula field])

You will need to check the checkbox on the field properties to allow HTML.

Comment

3 years ago

Ann

22 Points

Thank you!!!

What if i add the background color the date also when it is entered?

If([Days Delivered]<Days(0), "<div style=\"background-color:red;\"> *** i want this to be the date entered not a text*** </div>", [Days Delivered] )

what should i put there? i only see the one in quickbase with the urgent is entered but the date is a big range.