Skip to main content
Question

How can i have a due date turn red when the due date has passed

  • January 17, 2019
  • 0 replies
  • 87 views
Need a formula that will turn a date red when the due date has passed, your help is much appreciated 
    This topic has been closed for replies.

    Use a rich text field with something like this

    If(Today()>[DueDate],"<div style=\"font-size:10pt;color:red;font-weight:bold\">"&[DueDate]&"</div>",
    "<div style=\"font-size:10pt;color:black;font-weight:bold\">"&[DueDate]&"</div>")
    Terms & ConditionsAccessibility statement