Conditional formatting in FileMaker layouts

Intermediate

Apply dynamic colors, fonts, and styles to fields and objects based on calculation rules — without scripting.

What you'll learn

  • How to add conditional formatting rules to a field
  • How to write the condition calculation, including using Self
  • How to stack multiple rules with priority order

Conditional formatting applies visual changes to layout objects when a calculation evaluates to True — giving users instant visual feedback without any scripting.

1/3
1

Add a conditional formatting rule

Select an object in Layout mode, then Format > Conditional Formatting. Click Add and enter a calculation. Choose the formatting to apply when the condition is True.

FileMaker Script
// Condition to highlight overdue invoices in red:
Invoices::DueDate < Get ( CurrentDate ) and Invoices::Paid = 0

// Condition using Self (references the field the rule is on):
Self < 0
FileMaker layout parts — Header, Body, Footer, and moreHide Object When — dynamic visibility in FileMaker

Sign in to track your progress and pick up where you left off.

Sign in to FM Dojo