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

  • 0
  • 1
  • Question
  • Updated 3 months ago
  • Answered
Need a formula that will turn a date red when the due date has passed, your help is much appreciated 
Photo of Charles Chambers

Charles Chambers

  • 70 Points

Posted 3 months ago

  • 0
  • 1
Photo of donald lundgren

donald lundgren

  • 110 Points 100 badge 2x thumb
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>")