Format a column to change how it looks

Format a column to change how it looks

Format a column in a SharePoint list or library using the modern experience to change the way items look. Fill background color is available for Choice, Date, and Yes/No columns. Data bars can be applied to Number columns. For other column types, an advanced formatting mode is available.

Note: You may need to add columns to an existing library to access column formatting.

A list in SharePoint showing column formatting

Fill background color

Highlight different choices and dates with Fill background color. For example, you might name a column "Requires Review". You could use color to highlight who needs to review the file.

  1. In your list or library, select the column header for the column you want to customize.

  2. Select Column settings, then select Format this column.

  3. Select Fill background color to use the default palette, or select Edit template.

  4. Select the palette icon, then select your color preference for each option.

    The Edit template options for Background fill color for SharePoint column formatting
  5. When you're finished, select Save.

Data bars

Provide visual comparison of numbers with Data bars. For example, you might name a column "Effort (Days)." The length of a data bar could indicate how long an associated task might take.

  1. In your list or library, select the column header for the column you want to customize.

  2. Select Column settings, then select Format this column.

  3. Select Data bars to use the default palette, or select Edit template.

  4. Enter the minimum and maximum values for the data bar template.

  5. Select the palette icon, then select your color preference for each option.

    The Edit template options for Data bars for SharePoint column formatting
  6. When you're finished, select Save.

Note: Should you opt to clear your column formatting at a later date, SharePoint will not save your formatting options if you then decide later to re-enable it again.

Advanced mode

If you're comfortable using JSON, you can also add JSON directly using the Advanced mode.

  1. In your list or library, select the column header for the column you want to customize.

  2. Select Column settings, then select Format this column.

  3. At the bottom of the Format column pane, select Advanced mode.

  4. Enter the JSON you want to apply to the column.

    The Advanced mode JSON pane for SharePoint column formatting
  5. When you're finished, click Save.

For more information about the use of JSON for column formatting, see Use column formatting to customize SharePoint.

Expand your Office skills
Explore training
Get new features first
Join Office Insiders

Was this information helpful?

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.

×