Conditional formatting is a way you can format layout objects to change automatically when they meet specified conditions. For example, you can use conditional formatting to automatically display balances that are over 30 days past due in bold, red text. Conditional formatting settings affect only the way data is displayed or printed, not how data is stored in the database.
Conditional formatting has become an essential part of any FileMaker system because it makes tasks so much easier for the user. It allows the user to quickly identify certain variables that could otherwise be missed.
How to specify conditional formatting for objects:
- In Layout mode, select one or more objects.
- Choose Format menu > Conditional.
- In the Conditional Formatting dialog box, click Add to define a new condition.
- Specify the condition for formatting data in the selected objects.
To specify a format based on common conditions, for Condition choose Value is. Then choose one of the following conditions and set the parameters.
To specify a format based on a calculation, for Condition choose Formula is. Then click Specify to define the calculation.
Tip: Use the Self function to reference data for the selected object. For more information, see Self [FileMaker Help].
5. Specify the text and field fill format for data that meets the conditions you specified.
For example, select bold red text appears in a yellow field, when data meets your criteria.
Tip: Click More Formatting to see additional formatting options.
6. Click OK.
REMEMBER: CONDITIONAL FORMATTING ONLY AFFECTs THE WAY DATA IS DISPLAYED OR PRINTED, NOT HOW DATA IS STORED IN THE DATABASE.
Note: To see which fields have conditional formatting, choose View menu > Show > Conditional Formatting. You see a blue and red arrow icon in fields with conditional formatting.