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?

  • 0
  • 1
  • Question
  • Updated 3 years ago
  • Answered
Photo of Ann

Ann

  • 22 Points

Posted 3 years ago

  • 0
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 65,542 Points 50k badge 2x thumb
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.



 
Photo of Ann

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.
Photo of Ann

Ann

  • 22 Points
OR how do you make it the background color instead of font color?
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 65,542 Points 50k badge 2x thumb
Here is a help text link to background shading.

http://www.quickbase.com/user-assistance/Default.html#color_field.html