Today, we’ve added new option for Text/Formula – Text columns – colorization bases on whether the value contains certain text.

Before introducing this option you were able to perform this task using XHTML – Formulas, but their use is somewhat limited. New option works equally well while displaying the column on page, with e-mail notifications, document generation and Excel export.

Let’s see how it works:

At the bottom of the Text/Formula – Text column properties new block appears:


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

And the output would look like: