Conditional Formatting

You can use conditional formatting to customize the background colors and the font colors that are shown in the result grids. The colors are based upon the values in the grid cells.
You can add custom calculated columns to the existing query to apply conditional formatting. The columns that you customize are prefixed by certain keywords. The custom calculated columns are not visible in the grid.

This table shows the list of keywords:


Column Prefix	Description
F_BG	This prefix changes the background color. For example, F_BG_ITEM_CODE changes the background color of the ITEM_CODE field.
F_FG	This prefix changes the font color. For example, F_FG_ITEM_CODE changes the font color of the ITEM_CODE field.
DR_	This prefix adds the hyperlink to the column value and supports drill back feature. Syntax : `DR_<<objectsymbol>>_<objectColumnLabel>>` For example, DR_ITEM_Item Code, adds the hyperlink to Item Code column values and allows to drill back to the Item object. The symbols that support drill backs are Item, Formula, Specification, Project, Label Rule, Parameter Code, and Company.
F_STATUS_ICON	This prefix adds the status delay icon based on the status. MAJOR_DELAY, MINOR_DELAY, ON_TIME are the allowed and corresponding icons are displayed as shown below. MAJOR_DELAY A major delay is indicted by a red icon. ON_TIME An on-time status is indicated by a green icon. MINOR_DELAY A minor delay is indicated by a yellow icon.