Discussions

Expand all | Collapse all

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

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

    Posted 01-17-2019 17:36
    Need a formula that will turn a date red when the due date has passed, your help is much appreciated 


  • 2.  RE: How can i have a due date turn red when the due date has passed

    Posted 01-17-2019 17:42
    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>")