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!

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