Conditional Formatting

Visually format fields and objects based on conditions you choose.

What is Conditional Formatting

Are your vendor payments overdue? What contracts are expiring next month? Are you on time and under budget? Conditional Formatting lets you format layout objects to change automatically when they meet specified conditions.

You can set Conditional Formatting for text fields, FileMaker Web Viewer objects, merge fields, text-based buttons or layout symbols (e.g. date, time, page number, etc.). Choose how objects display by modifying fonts, styles, size, text color, and fill color. Pick from a list of 20 pre-defined conditions or create your own with a calculation for enhanced reporting. Conditional Formatting settings affect only the way data is displayed or printed and not how data is stored in the database.

How you can use it

Use Conditional Formatting to give your sales reports visual impact. If you want to quickly identify how each region is performing quarter over quarter, set the revenue fields to automatically appear a certain color when a region falls below the forecast or when it outperforms expectations. With Conditional Formatting you can easily identify trouble spots that need attention or shining stars that are contributing to your organization’s success.