Applying conditional and value formatting in your tables lets you customize how your table displays certain values.
Apply Conditional Formatting
To apply certain content-specific styles (like font and background color) to your cells, you can use conditional formatting.
In embedded tables, you can create rules that apply to that specific table. To create a rule:
- Select the table.
- From the Edit toolbar, click Conditional Formatting .
- Select Add a Rule to open the conditional formatting panel.
Conditional formatting in embedded tables works just like rules in Spreadsheets. Learn more about using conditional formatting.
Adjust Value Formatting
The Formats panel allows you to set how the table handles different entry forms, including how formulas handle rounded values.
To view value formatting options:
- Select a cell or table.
- From the Properties panel, open the Formats tab.
- Under Value Formatting, select what type of input your cells use. You can also change the Entered In, Shown In, and Formula options.
Advanced Formatting Options
Depending on your selected format, you can adjust advanced options for how values are displayed in your table.
For Accounting, Currency, Number, and Percent formats, the Advanced Formatting options automatically change based on the typical settings for those format types. However, you can manually change these settings to match your desired display format.
The Date option allows you to change how your table displays dates. This option automatically updates to match your document's locale, but you can manually change the date display from this panel.