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: