Conditional Formatting
Conditional formatting in Portiny automatically highlights table cells based on record values. Define rules with conditions and visual styles — bold, text color, background color, or strikethrough. Rules combine with configurable priority and carry over to Excel and PDF exports.
Conditional formatting that highlights what matters
An overdue invoice, a negative stock balance, an order flagged as urgent. These shouldn't hide among hundreds of rows. Conditional formatting in Portiny colors table cells automatically based on rules you define — no code required.
Each rule pairs a condition with a visual style. Conditions use the same query language as view filters, so there's nothing new to learn. The formatting carries over to Excel and PDF exports, keeping your reports consistent.
Rules and priority
Visual condition builder
Build each condition in a graphical editor — pick a field, an operator, and a value. No scripting. A condition can reference any field on the record, not just the column the rule belongs to. Example: color the "Status" cell red when the due date is in the past.
Style merging with priority
Every rule has a numeric priority. Lower number means higher importance. When multiple rules match the same cell, their styles merge — a later rule only overrides the properties it defines. The result is layered formatting without conflicts.
Manual scanning vs. automated highlights
Without formatting
- Critical records buried in tables with hundreds of rows
- Daily filtering eats up time that could go elsewhere
- Exported files are plain — all context lost
- Anomalies discovered only during manual reviews
With conditional formatting
- Urgent values stand out instantly through color coding
- Rules evaluate automatically — no daily routine needed
- Styles carry over to Excel and PDF exports
- Multiple rules on a single column merge intelligently
6 style properties per rule
Each rule can set bold, italic, underline, strikethrough, text color, and background color — in any combination. Leave the condition empty to create a default style for the entire column. A live preview in the admin panel shows the result before you save.
Available formatting options
Mix and match any of these in a single rule. The result shows up in the table and in every export.
Color-code your data today
Sign up and set your first conditional formatting rules. See how quickly a plain table turns into an actionable dashboard.
Try for freeRelated Features
Try everything yourself
After signing up, you can create a demo project — a sample construction company with 9 modules and test data. Everything you see in the videos, you can click through and try yourself.