AX1476
You can use the spreadsheet Conditional Formatting feature in Formatted Grid components, with some limitations. This is only available when the grid is configured to use spreadsheet formatting. Thematic grids will ignore the spreadsheet formatting, including any conditional formatting.
When setting up the conditional formatting in the spreadsheet, keep in mind the following:
-
The condition must use a formula. This means that when you define the formatting rule in Excel, the rule type must be Use a formula to determine which cells to format. If any of the other rule types are used, an error will result when the form is rendered.
-
The colors specified for the conditional formatting may not display in the Axiom form exactly as defined within the spreadsheet. You should test the form and make adjustments as needed to achieve the color that you want.
NOTE: If you need to specify the color exactly, then instead of using Excel's conditional formatting you can define your own conditional formula that dynamically displays a content tag to impact the cell colors. For more information, see Using content tags in Formatted Grids.
-
The same conditional formatting limitations that apply to the Windows Client also apply to use in Axiom forms. For example, the following conditional format configurations are not supported: cross-sheet references, overlapping formats, and more than three formats per cell.
