Format a column to change how it looks
Applies ToSharePoint in Microsoft 365 Microsoft Lists

Format a column in the Lists app or a SharePoint list or library using the modern experience to change the way items look. Data bars can be applied to Number columns. Fill color is available for Choice, Date, and Yes/No columns. Choice columns have shaded, pill-shaped backgrounds for option names. 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.

Formatted columns in SharePoint document library

Fill color & conditional marking

Highlight different choices and dates with Fill color. For example, you might have a column named "Requires Review". You could use color to highlight which files in the library need to be reviewed. In this example, items marked "No review required" have a green background, while files requiring a review have a pink background.

  1. In your list or library, select the column header for the column you want to customize. (In this example, we use Name column).

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

  3. Under Format column, select Conditional formatting, then select Manage rules

  4. Under Conditional formatting, select Add rule.

  5. Define a rule: For our example, we select If Requires Reviewis equal toNo review, Show list item as mint green. Select Save. Add other rules as needed. To add a rule, select the back arrow, then select Add rule

    For this example, we've also added If Requires Reviewis not equal toNo review, Show list item as Peach.

    Create a rule for formatting a column.

  6. When you're finished, select Save.

Data bars

You can 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.

    Options for formatting data bars in a SharePoint list column.
  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.

Need more help?

Want more options?

Explore subscription benefits, browse training courses, learn how to secure your device, and more.

Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.