I’m sharing with you the guideline about formatting views in Microsoft Lists. You can easily improve the look & feel of your business apps. Four tricks I’m describing will help you to build a KPI-like experience for the data presented on the list. Style your Microsoft Lists using formating and make them look beautiful.

⏰ Timestamps

00:00 – Title

00:15 – Introduction

00:43 – Simple formatting

01:15 – Complex formating

02:02 – Choice pills

02:53 – Conditional styling

03:25 – Conclusion

03:37 – Outro

Style Microsoft Lists and create beautiful app in Microsoft 365

PREPARE FOR GENERATIVE AI ERA

Prepare yourself and your organization for Generative AI and Microsoft Copilot.

? Transcription

Today I would like to teach you 4 ways to make your Microsoft List look beautiful.

Microsoft List is a great solution for collaboration and sharing data with your colleagues.
Building a modern business application using Lists is very simple and fast.
When you will deliver your business app you need to engage your team or department to use it.
Remember that people judge things with their eyes, so you have to make your Microsoft List looks great.

The first styling option will allow you to improve the look and feel of the list with the simple row formating.
If you need something quick to improve the readability of the Microsoft List view this is the solution for you.
You can easily switch the formating of the current view and alternating row style.
You can break the flat view set by design.
This is not something that will make a great impression on your colleagues but is a really quick solution.

The next option I would like to share with you is based on the changes made for the way how column style is presented.
It is possible to set a static style for the most crucial columns which will emphasize their importance.
You have a few options to do that.
At first, you can set a unique color for the text and the background.
You can also format the font, add an icon to the text, or add borders around the field.
Based on this kind of changes you can navigate users attention to such field
As you can see the list starting looks more interesting.

Another quite easy trick in the styling of the Microsoft list is using pills style for the Choice fields.
Choice columns contain a kind of dictionary presented to the users in the drop-down menu.
You have the possibility to set specific colors for the available option in that choice filed.
Set preferable colors for the pills and differ the reading way of the set values.
This quite a simple but efficient KPI-like solution.

The last feature you should focus on is Condition formating.
You can build dynamic styling rules based on the logic rules.
Thanks to such an approach your list will change the staling based on the rules you will set.
In this example, the colors of the fields will depend on the current date.
So every day the report will present a different way.

I hope these styling methods will help you to build beautiful and useful applications.
Play with view formatting and collaborate better.

Style Microsoft Lists and create beautiful app in Microsoft 365