Discussions

Expand all | Collapse all

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!

  • 1.  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!

    Posted 09-20-2017 17:28
    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!


  • 2.  RE: 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!

    Bronze
    Contributor
    Posted 09-20-2017 17:48
    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


  • 3.  RE: 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!

    Posted 09-20-2017 17:53
    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


  • 4.  RE: 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!

    Bronze
    Contributor
    Posted 09-20-2017 17:56
    This is simpler and I just noticed I forgot a closing, woops. I'd go with this solution.


  • 5.  RE: 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!

    Posted 09-20-2017 18:00
    It happens to us all!