Office 365: Formatting with data bars numeric columns in SPO lists and document libraries (I)!

As you know, we have been able for a while to apply JSON formatting to SharePoint Online (SPO) columns by means of custom JSON code or by using the conditional formatting feature available for Date, Yes/No and Choice columns. Additionally to these two options we can also start using the new data bars formatting available for numeric columns added to any list or document library. To start using this new feature, we only need to access the formatting option for a numeric column so the new “Data bars” templates is shown:


This new formatting template allows to define the minimum and maximum values to be used in the Data bars for both positive and negative numbers and also the background color to be used:


And of course, we also have the possibility to access the advanced mode in the column formatting and go back to work with JSON code.


Introduce tus datos o haz clic en un icono para iniciar sesión:

Logo de

Estás comentando usando tu cuenta de Cerrar sesión /  Cambiar )

Google photo

Estás comentando usando tu cuenta de Google. Cerrar sesión /  Cambiar )

Imagen de Twitter

Estás comentando usando tu cuenta de Twitter. Cerrar sesión /  Cambiar )

Foto de Facebook

Estás comentando usando tu cuenta de Facebook. Cerrar sesión /  Cambiar )

Conectando a %s