Style your tables with conditional formatting

Use conditional formatting to style table views and view elements based on conditions.

Use conditional formatting to make table views and table elements on a record form easier to scan with colors and icons based on conditions.

Set up the conditions and styling

1

Choose the table

• Go to the table view you want to format.
• Click one of the column headers.
• Choose Conditional formatting.

2

Set up a rule

• Set the condition by choosing a column, an operator, and a comparison value.
• Choose whether to format the Cell or the whole Row.
• Set the text style, colors, or icon in Value. Available highlighting options are:

  • Row

    • Text styles: Bold, Italic, Strikethrough
    • Text color, Background color
  • Cell

    • Text styles: Bold, Italic, Strikethrough
    • Text color, Background color, Text highlight color
    • Recently used icons
• Click More colors or Select icon to chose from more color options or icons.

• Click Apply to confirm your choices or + Add rule to add more rules if needed.

3

Arrange the rule order

In some cases, more than one rule applies to the same Cell or Row. Because only one format can be shown at a time, arrange the rules according to their ranking. Use the ⋮⋮ handle on the left to drag a rule up or down.

Ranking order of rules

Rules need a ranking because more than one rule can apply to the same Cell or Row.

When multiple rules apply:

• The first matching rule wins for each formatting option.
• If a rule does not set a formatting option, Ninox uses the next applicable rule for that option.
• A matching Cell rule overrides a matching Row rule, even if the Row rule appears first.

Rule ranking is applied to each formatting option separately. For example, if a higher-ranked rule sets only the background color, Ninox can still take Italic from a lower-ranked applicable rule.

Let's take a look at an example:

Set two rules that target the same records. In the first rule, set a background color and a text color. In the second rule, set a different background color.

The second rule does not apply because the first rule already set the background color.

Now change the order of the two rules. In the new first rule, set I Italic. Then add a third rule for a cell. In that rule, set Bold, Text color, Background color, Text highlight color, and an Icon.

The final result is built in layers:

• Rule 1 sets the background color and italic text style for matching rows.
• Rule 2 sets the text color for those rows.
• Rule 3 sets the background color, text color, and icon for the matching cell.

This example shows how Ninox evaluates each formatting option separately. A row can take its background color from one rule, its text color from another, and a cell-specific style or icon from a third rule.