Advanced conditional formatting rules
ExpertStack multiple conditional formatting rules with complex expressions to create dynamic, data-driven visual feedback.
What you'll learn
- How rule priority works when multiple conditions are true
- How to reference related fields and global variables in conditions
- How to use conditional formatting to create a status traffic light
Conditional formatting lets each layout object have up to 25 rules that change its appearance based on a calculation. Rules are evaluated in priority order, with the first matching rule applied. Complex expressions — referencing related fields, global variables, or Get() functions — enable rich data-driven UIs without scripts.
1/3
1
Rule priority: first match wins
Rules are evaluated from top to bottom. The first rule whose condition is true applies its formatting and stops. Drag rules up to increase their priority.
FileMaker Script
// Status field conditional formatting: // Rule 1 (highest): Status = "Overdue" → Red background // Rule 2: Status = "Due Soon" → Yellow background // Rule 3 (lowest): Status = "Paid" → Green text // If Status = "Overdue", rule 1 fires and rules 2 & 3 are ignored
Sign in to track your progress and pick up where you left off.
Sign in to FM Dojo