Microsoft Lists Formatting Examples

In the last tutorial, we discuss in detail Microsoft Lists, the new Microsoft 365 App. Now, let us discuss a few Microsoft Lists formatting examples.

Here we will see how to add columns to a Microsoft Lists and then also we will see how to do some column level formatting, view level formatting. How a Microsoft Lists look like in Gallery view.

You may like Microsoft Lists – Create a List from Excel

Microsoft Lists Formatting Examples

If you have not yet created a list in Microsoft Lists, then check out the video on Microsoft Lists. For this example, I have created a blank list that will have only one column as Title.

By default the list looks like below:

Microsoft Lists Formatting
Microsoft Lists Formatting Examples

Rename Title Column

The default column is the Title column, and we may not want the name Title in all our business requirements. So we need to change or rename it.

Click on the small arrow right to the column, then click on Column settings -> Rename.

Rename title column microsoft lists
Rename title column microsoft lists

This will open the Rename column dialog box. Here provide the new name that you want to rename to and then click on the Save button.

How to rename title column microsoft lists
How to rename title column Microsoft lists

Once you click on Save, the Title column name will be changed.

Add a new column to Microsoft Lists (Choice Column)

According to your business requirements, we can add columns to a Microsoft Lists.

Open the Microsoft List, then click on + Add column -> Choice. You can choose the column type according to your requirement.

add choice column to microsoft lists
add choice column to Microsoft lists

Then in the next we need to provide the column name, description and then you can enter the choices like:

  • Completed
  • Not Started
  • InProgress

And it looks like below:

How to add column in Microsoft lists
How to add column in Microsoft lists

Without any other formatting, the Microsoft list with some data looks like below:

add column in Microsoft lists
Microsoft Lists

Microsoft Lists View Formatting – Alternate row styles

In each column, you will see an option Format this column, that you can use to format a Microsoft Lists column. The options might change based on the selected column data type.

Click on the column -> Colum settings -> Format this column.

Microsoft Lists Formatting example
Microsoft Lists Formatting example

Here you can see both the options, Format view and Format columns.

In the Format view, you can either change the row styles from Alternating row styles or you can do the Conditional formatting.

microsoft lists format column
Microsoft lists format column

Select the Alternating row styles and by default it will display the Grey and White color for alternate rows.

microsoft lists format view
Microsoft lists format view alternating row styles

Once, you click on Edit row styles, you can change the background color for Odd rows and Even rows and the view will looks like below:

microsoft lists alternate row styles
Microsoft lists alternate row styles

Microsoft Lists View Formatting – Conditional Formatting

We can add some rules and can do Microsoft Lists view formatting with conditional formatting. There select “Conditional formatting” like below:

microsoft lists view conditional formatting
Microsoft lists view conditional formatting

Here click on Manage rules. By default there will be one rule Sow all values as or click on … and then click on Edit rule like below:

microsoft lists view conditional formatting example
Microsoft lists view conditional formatting example

In the Edit rule you can write the condition, If <column name> then condition and then the value.

Then you can change the color in Show list item as.

microsoft lists formatting rule
Microsoft lists formatting rule

This is how the conditional view looks like in Microsoft Lists.

Here you can also like more And and Or conditions with if like below:

Microsoft lists formatting rule and or condition
Microsoft lists formatting rule and or condition

This is how we can add rules for conditional formatting in Microsoft Lists.

Microsoft Lists Column Formatting

From the same place, we can also do Microsoft lists column formatting. Click on Format columns, then you can choose the column. In this case, I have selected the Status column.

There, you have the options to change the color:

  • Background colors
  • Choice pills
  • Conditional formatting
Microsoft Lists Column Formatting
Microsoft Lists Column Formatting

Here, select Choice pills, then click on Edit styles. Then based on the column values you can write the rules like below, If Status is Completed then change the background column to green. You can add multiple rules like below:

Microsoft lists column formatting rules
Microsoft lists column formatting rules

For each value, you can click on the A/Edit icon, and then you can change the font, font color, Icon, and even we can change the Icon alignment.

Microsoft lists column formatting rules with conditions
Microsoft lists column formatting rules with conditions

Now, you can able to see the icon in the left side of each Status whose value is Completed.

Microsoft lists column formatting rules with conditions
Microsoft lists column formatting rules with conditions

You can also Add Conditional formatting. Here you can see If Status is equal to InProgress then the background color will be Yellow and also there will be an icon.

Check out the below list view.

Microsoft lists column conditional formatting
Microsoft lists column conditional formatting

This is how the Microsoft Lists View looks like.

Microsoft Lists Gallery View

By default, the Microsoft Lists gallery view looks like below:

Microsoft Lists Gallery View
Microsoft Lists Gallery View

If you want to edit something in the layout. In the Format view, Choose layout as Gallery. Then click on Edit card.

Microsoft Lists Gallery View formatting
Microsoft Lists Gallery View formatting

In the Card Designer, you can Select or Deselect the Columns that you required in the Gallery view.

Microsoft Lists Gallery View column selection

This is how we can customize the Gallery view in Microsoft Lists.

Microsoft Lists Alert me

Like in SharePoint Online, in Microsoft Lists, we can also create Alerts for Microsoft Lists and for each items.

From the command bar click on Alert me like below. You can configure Alert me like the way we configure in SharePoint Online lists. You can check out an article on SharePoint alerts – Create and Manager Alerts in List or Library.

Microsoft Lists Alert me
Microsoft Lists Alert me

You may like the following the SharePoint tutorials:

Here, we learned some Microsoft lists formatting examples. We saw Microsoft lists view formatting and Microsoft lists column formatting.

>