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!

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

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