Colour rows by rule#

Conditional formatting colours rows in the grid by rules you define, so the ones that matter stand out. A rule might paint every row where an order is unpaid, or every customer with a low balance. Unlike a filter, formatting hides nothing: every row stays in the grid, and Database Client colours the ones that match your rules.

The controls sit in the Conditional Formatting bar above the grid. Select it to expand the panel, then use the plus button to add a rule. Each rule carries a count, so you can see how many you have set.

Set a rule's colours#

Each rule has a background colour and a text colour. Two colour pickers set them, with a live preview of a matching cell. Choose colours that read clearly against each other.

Set the match condition#

A rule matches rows through a condition group. Within a group you add conditions, each a column, an operator, and a value. The operators cover the usual comparisons (=, !=, >, <, >=, <=), text matching with LIKE and Contains, and the empty checks IS NULL and IS NOT NULL.

A group joins its conditions with AND or OR, which you switch at the top of the group. For anything more involved, nest a group inside another. A nested group expresses rules such as "A and either B or C". Changes take effect as you make them, so the grid recolours immediately.

When more than one rule matches the same row, Database Client stripes the row with each rule's colour. You then see that several rules apply.