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.
Stuck is a valid status
Need a second brain on this one?
If this lesson just collided with your real schema, script stack, or deadline, book consulting and turn the confusion into a concrete plan.
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.
// 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