AX1476

Using Conditional Formatting in spreadsheet-formatted grids

Certain features of Microsoft Excel's Conditional Formatting are supported for use in Formatted Grid components, if the grid uses the legacy spreadsheet formatting option.

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.