Sign in with Microsoft
Sign in or create an account.
Hello,
Select a different account.
You have multiple accounts
Choose the account you want to sign in with.

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?

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.

Was this information helpful?

What affected your experience?
By pressing submit, your feedback will be used to improve Microsoft products and services. Your IT admin will be able to collect this data. Privacy Statement.

Thank you for your feedback!

×