Skip to Main Content
Feature Request FR-4142
Product Area Page Components
Status CLOSED

1 Voters

In Interactive Reports and Grids, Highlight a cell based on the value in another cell

rosen13 Public · Dec 10 2024

Idea Summary
Currently, you can highlight a cell only based on the value in that cell. We need the option of highlighting a cell based on a value in a different cell. For example, we may have a field that is not displayed, but contains a value that should tell APEX to highlight a different cell. For example, a cell called Name (i.e., Bob, Bill, George, etc.). Another cell called Name_Highlighting with the value of “Yes” under certain circumstances. In highlighting, we should be able to highlight Name when Name_Highlighting = Yes. This would make a huge difference in formatting reports.

Use Case
Any report customization

Preferred Solution (Optional)
In the highlighting dialog, simply include the cell to highlight and the cell which the formula is based on.

This request is likely a duplicate of FR-3305.

Comments

Comments

  • john.snyders APEX Team OP 5 weeks ago

    The interactive grid region does support this feature with the end user Highlight dialog you can choose the highlight column independent of the column used in the expression.

    You can also use the grid cellCssClassesColumn column property via the Column Initialization JavaScript Function attribute. You can add a query only column such as CELL_CLASS that contains the class you want to add to the cell and specify it like this:

    function(options) {
    options.defaultGridColumnOptions = {
        cellCssClassesColumn: "CELL_CLASS"
    }
    return options;
}