I am trying to change the color of the font in a date column. I want to be able to change the color to red. Please help!

  • 0
  • 1
  • Question
  • Updated 1 year ago
  • Answered
I am trying to change the color of the font in one column, it is a date column. I want to be able to change the color for any date in the column named "Report Deadline" to be any date after today to be red. Please help!
Photo of Nicole Pylar

Nicole Pylar

  • 70 Points

Posted 1 year ago

  • 0
  • 1
Photo of Jordan

Jordan

  • 1,574 Points 1k badge 2x thumb
Based off of this http://help.quickbase.com/user-assistance/Default.html?_ga=2.144787380.1643315432.1505749188-2217634... try:

If((ToDays([Report Deadline])-Today()) < 0, "<div style=\"color:white; background-color:#FF0000;\",[Report Deadline])
Put this in a formula text field with HTML enabled
(Edited)
Hi Nicole.

Like Jordan said, you can create a formula text field to do this. Instead of displaying the [Report Deadline] field in your reports, you'll add this new field as a column.

Make sure to check the box that says "Allow some HTML tags to be inserted in the field." Here's your formula:
If ([Report Deadline] > Today(), "<span style='color:red;'>" & [Report Deadline] & "</span>", ToText([Report Deadline]))
Note that if [Report Deadline] is a date/time field, you'll need to wrap it in the ToDate() function.

PHILLIP DENNIS, CMA
Principal | Watkyn LLC
(954) 900-6690 | www.watkyn.com

Watkyn LLC
Photo of Jordan

Jordan

  • 1,574 Points 1k badge 2x thumb
This is simpler and I just noticed I forgot a closing, woops. I'd go with this solution.
It happens to us all!