MMPlugs Logo

Docs / Conditional formatting

Conditional formatting

Conditional formatting

Conditional formatting lets you highlight rows based on values in any column. "Stock status = out of stock" turns the row red. "Revenue > $1M" turns the row green. You can stack multiple rules.

Add a rule

  1. Open a table in the editor.
  2. Click Conditional Formatting in the toolbar.
  3. In the modal, click + Add rule.
  4. Pick the column, an operator, and a value to compare against.
  5. Pick a background colour and (optionally) a text colour.
  6. Save the modal, save the table.

The rule applies to every row where the chosen column matches the condition. Cells across the whole row get the colours, not just the matched column.

Operators

| Operator | Matches when | |—|—| | Equals | The cell value equals the target (case-insensitive). | | Not equals | The cell value differs from the target. | | Greater than | Both values are numeric and cell > target. | | Less than | Both values are numeric and cell < target. | | Greater or equal | Numeric >=. | | Less or equal | Numeric <=. | | Contains | The cell text contains the target substring. | | Starts with | The cell text begins with the target. | | Is empty | The cell has no content. | | Is not empty | The cell has any content. |

Rule order and overlapping matches

Rules are checked top to bottom. When multiple rules match the same row, the LAST matching rule's colours win. Use this to layer general rules with specific overrides — put the catch-all at the top, the exception at the bottom.

How it renders

MMTable evaluates rules server-side at page render time and emits the matching colours as inline styles. The cells look correct from the very first paint — no flash of unstyled rows, no JavaScript dependency. After the page's interactive JavaScript loads, dynamic re-paints (after sort, filter, pagination) reapply the same rules.

Limitations

Rules compare against the column you choose. To match against a computed value (formula output, or a value derived from multiple columns), put the computation in a hidden column and compare against that column.

Rules apply only to body rows, not the header or footer.