Formatting Data

You can apply different types of formatting to data.

This task shows you how to:

Before you begin: Some of the following formatting options might not be available for all columns.
See Also
About Conditional Formatting

Apply Conditional Formatting

  1. Click at the right of the column header.
  2. Click Set conditional formatting.
  3. Click Add a Rule or .

    To delete a rule, highlight the rule and click .

  4. Configure the criteria for applying formatting:
    1. Select is or is not to select the matching behavior.
    2. Select the operator to use for matching. Options depend on the data type of the property.
  5. Set the values for matching.
  6. Select the colors to apply when a match is found.

    If a range of values can match, you can specify the gradient to use for the limiting values.

  7. Optional: Under Apply Formatting To, apply the conditional formatting to one or more columns or rows that contain the same data type or to the entire table.

The data updates to use the conditional formatting rules.

Use Scientific Notation

  1. Click at the right of the column header.
  2. Select Scientific Notation, and then select True or False.

The data updates to use or not use scientific notation.

Apply Numeric Formatting

  1. Click at the right of the column header.
  2. Select Numeric Display, and then select one of the following:
    • Auto - Display the original data value.
    • Decimal Places - Display from 0 to 9 decimal places.
    • Significant Figures - Display from 1 to 10 significant figures.

The data updates to use the selected numeric formatting.