Column Value Colorization

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

Moreover, the column value colorization works equally well while displaying column values on the form, with e-mail 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 the colorization is based on whether a value contains a certain text. Say there is the 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 – yellow, Complete – 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, the second box specifies a background color when a match is detected. The foreground color (black/white) is detected automatically and based on 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 the colorization is based on the conditions whether a value is less than an indicated number. Also, a color of an alternative value can be specified in the “otherwise” field.

For example:

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 and based on 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 the colorization is based on the conditions whether a value is less than an indicated number. Also, a color of 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 and based on 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 colorization of values. Some examples of such colorization are provided here >>

Next: Pattern Validation for Text