Column Value Colorization

To draw users’ attention to specific values, you can colorize them in Text, Numeric, Duration, Formula-Text, Formula-Numeric, Formula-Duration, and Formula-HTML columns.

Moreover, column value colorization works equally well when displaying column values on the form, with email notifications, document generation, and Excel export.

To display the colorization in a Lookup column referring to a colorized Text, Number, Duration, Formula-Text, Formula-Number, or Formula-Duration column, you have to uncheck the Display As Link option in the Lookup column settings.

Text and Formula-Text columns

In a column of the Text type, colorization is based on whether a value contains certain text. Suppose there is a Status text column in a table. This column comprises "Complete," "Overdue," and "In Progress" values. You need to highlight the Overdue status in red, In Progress in yellow, and Complete in green.

To specify the colorization for Text or Formula-Text column values, edit column settings and check the Colorization checkbox in the Advanced Options. In the above-mentioned example, the Status column values should be colorized in the following way:

The first box allows you to input a string to check for containment, and the second box specifies a background color when a match is detected. The foreground color (black/white) is detected automatically based on the background’s luminance, so you can use dark and light colors equally well.

Numeric and Formula-Numeric columns

In a column of the Numeric type, colorization is based on whether a value is less than an indicated number. Also, a color for an alternative value can be specified in the "otherwise" field.

For example you can colorize negative values.

To specify the colorization for the Numeric or Formula-Numeric column, edit column settings and check the Colorization checkbox in the Advanced Options. In the above-mentioned example, the Statistics column values should be colorized in the following way:

The foreground color (black/white) is detected automatically based on the background’s luminance, so you can use dark and light colors equally well.

Duration and Formula-Duration columns

In a column of the Duration type, colorization is based on whether a value is less than an indicated number. Also, a color for an alternative value can be specified in the "otherwise" field.

For example:

To specify the colorization for the Duration or Formula-Duration column, edit column settings and check the Colorization checkbox in the Advanced Options. In the above-mentioned example, the Delivery Days column values should be colorized in the following way:

The foreground color (black/white) is detected automatically based on the background’s luminance, so you can use dark and light colors equally well.

Formula-XHTML columns

If you are familiar with XHTML, you can use Formula - XHTML columns for the colorization of values. Some examples of such colorization are provided here.