Applying Conditional Formatting to Custom Grid Widgets in Bold BI?

Conditional formatting is a powerful feature that allows you to apply specific formatting to cells within a grid based on certain conditions. This can be particularly useful in custom grid widgets such as Frozen Grid columns and Stacked Header Grids to highlight important data or to make the grid more readable. Here’s how you can apply conditional formatting to these custom widgets:

Steps to Apply Conditional Formatting

1. Configure the Custom Grid Widget Data: Before applying conditional formatting, ensure that your custom grid widget data is fully configured and ready for use.

2. Access the Properties Section: Navigate to the properties section of your custom grid widget. This is typically found within the widget settings or by right-clicking on the widget and selecting properties.

3. Locate Conditional Formatting Options: Within the properties section, look for the option labeled ‘Conditional Formatting’. This is where you will define the formatting rules.

4. Define Format and Condition Columns:

   • Format Column: Specify the column(s) to which you want to apply the formatting.
   • Condition Column: Indicate the column(s) that contain the values that will trigger the conditional formatting.

5. Set the Condition Value: Enter the value in the condition value text box that will serve as the trigger for the conditional formatting. This value will be compared against the data in the Condition Column to determine if the formatting should be applied.

6. Choose the Condition and Colors:

   • Condition: Select the condition that must be met for the formatting to be applied (e.g., greater than, less than, equal to).
   • Background Color: Pick the color that will be used for the cell’s background when the condition is met.
   • Foreground Color: Choose the color for the text within the cell when the condition is met.

7. Apply and Review: After setting up the conditional formatting, apply the changes and review the grid to ensure that the formatting is working as expected. The cells in the Format Column should change their foreground and background colors based on the specified conditions.

Visual Aid

For further clarification, it is often helpful to include a visual example or screenshot showing the conditional formatting in action. This can demonstrate the expected outcome once the conditional formatting rules have been applied.

Additional References

• How to Freeze Columns and Rows in Custom Grid Widget in Bold BI?
• How to Add a Stacked Header Grid Custom Widget in Bold BI?