There’s a new wizard based, easy user interface for column conditional formatting in SharePoint Online!! That means you don’t have to know JSON code in order to do some conditional formatting on your columns!!!!!!
This doesn’t work on every column type, there are still limitations, but it does give some basic options.
Right now this only works on these types of columns:
- Yes/No (boolean)
It’s pretty simplistic. There are only a few ways you can format them, so if you need to do anything more complex than what you see out of box, you can still use JSON.
Here’s how the new formatting works.
Click the heading of a column, click Column settings, and choose Format this column. The one in this example, Status, is a choice column.
In the panel on the right side of the screen, the panel will have the name of your column at the top. Mine says Format Status column, because I selected the column called Status. You can click the checkbox to turn on some generic, default colors, or you can click Edit Template, to configure further. To do formatting with code instead of this wizard, click Advanced mode.
On this next screen, for a choice column, you’ll see a list of all the choices that exist for that column, with a little color palette icon next to each.
Click a color palette, and you’re presented with a set of (fairly limited) colors to pick from. You can even choose No fill if you’d like.
Configure each color if you’d like, and click Apply. At any time, click Reset to default style, to remove the conditional formatting.
For a date column, the choices are a little different. A date column will only give you three choices. By default, each one in relative to today, but you can click the drop-down on each, to change it to a specific date instead.
For a Yes/No boolean column, it’s only going to have two choices obviously, one color for Yes, and one color for No.
Here’s mine with a couple of choice columns, a date, and a yes/no, all formatted:
After formatting the columns, it’s still possible to see the code and tweak it if you’d like.
Go to list/library settings, and click the name of a column. Scroll down to see the Column Formatting box, and dig in.
That’s it for now, happy conditional formatting! Also, if you’d like to learn about this and more, check out my SharePoint Power User course!