Thursday, November 12, 2015

Conditional Formatting in SharePoint 2013/2016 and Office 365

Conditional formatting has always been a pain point in SharePoint 2013 and SharePoint Online (Office 365). Especially for those working with SharePoint 2007 and 2010 where you were able to do conditional formatting using SharePoint Designer. In SharePoint 2013 and Office 365 this functionality is gone.

You can still use different JavaScript hacks (i.e. use some calculated columns + JavaScript to apply conditional formatting to the row). There are lots of blog posts about that, but the main problems with all of those are amount of time you have to invest to produce the result and the fact that it is practically out of bounds of the regular SharePoint user.

My company Sharepointalist was diligently working on making conditional formatting features accessible and usable by the regular SharePoint user. We have done an enormous work and I am very proud to showcase some of the features of our new product SharePoint List Booster.
List Booster works as an add-on on your regular out of the box SharePoint list views (any lists and document libraries). It allows you to style your list, apply color schemes, manage font-styles and colors - all on top of you regular SharePoint user interface.

Using List Booster you can easily apply different conditional formatting rules including:

  • Text Rules;
  • Date Rules;
  • Numeric Rules (including currency);
  • Ranking Rules (Top, Bottom, Top %, Bottom %);
  • Averages Rules (equals average, above average, below average, etc.)

You can also use various indicators allowing to create various traffic lights.