Conditional and value formatting in tables

Applying conditional and value formatting in your tables lets you customize how your table displays certain values. Conditional formatting in embedded tables works just like rules in Spreadsheets. Learn more about Conditional Formatting in Spreadsheets. 

Apply conditional formatting

To apply 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:

1. Select the table.
2. From the Edit toolbar, click Conditional Formatting.
3. Select Add a Rule to open the conditional formatting panel.

Adjust value formatting

The Formats panel lets you set how the table handles different entry forms, including how formulas handle rounded values.

To view value formatting options:

1. Select a cell or table.
2. From the Properties panel, open the Formats tab.
3. 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 the 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.

Note: For values formatted as Number, Accounting, Currency, or Percent, you can choose Use alternate display for zeros in the Format panel. This allows you to display zeros as an em dash, en dash, hyphen, or blank.

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. 

Create custom dates

If you don't see your desired date format in the Date display options, you can set up a custom date format. To add a new format:

1. Select a cell in your table and open the Formats panel. Make sure your Format is set to Date .
   
2. Under Date Options, click the arrow to view display settings.
3. Click Custom Date Format at the bottom of the menu.
   
4. Type your custom format in the text box. Use m, d, and y to represent the values for month, day, and year—check the table for a full list of text options.
5. Click the checkmark to save your format.
   

Custom date entry guide

Use the following text strings to manage how your date is displayed: