You can customize the display of views in lists without changing the list data by adding formatting.

Anyone who can create and manage views in a list can access view formatting. The Compact list view condenses list items to make it easier to view more items at once. The Gallery view shows list items as cards, allowing you to emphasize photos of list items. To create a custom view, select All items > Format current view.

An example of a formatted view

A standard view, without formatting, has the same style for every row.

A list without formatting applied

Alternating row formatting

Image of a list with alternating rows highlighted

  1. Highlight alternating rows by selecting Edit row styles.

  2. Select the edit icon to choose a highlight color. You can also adjust the font size, change the font style and add a border by selecting More styles.

Conditional formatting

With conditional formatting, you can highlight rows based on rules.

With view formatting, you can highlight rows that meet a condition.

  1. Select Manage Rules > + Add rule.

  2. Choose a column to base the rule on.

  3. Choose a comparison: either is equal to or is not equal to.

  4. Type a value to compare the chosen column to.

  5. Select the edit icon to change the appearance of items affected by the rule.

This example shows conditional formatting with the status column set equal to "Blocked".

Image of a list with the second item, which has a status of Blocked, highlighted

Image of a rule that highlights items with the status of Blocked

You can edit and delete previously created rules by going to Manage rules and selecting the ellipses(...) next to the name of the rule.

To use view formatting with JSON, select Advanced mode.

The full reference on list view formatting JSON has more examples you can copy, paste, and edit.

Need more help?

Expand your skills
Explore Training
Get new features first
Join Microsoft Office Insiders

Was this information helpful?

What affected your experience?

Thank you for your feedback!

×