Share via

Conditional Formatting with Calculated Columns in SharePoint

  • Article

Introduction

There are a variety of ways to add color, images coding to your SharePoint lists and document libraries, from embedding custom code on your page to creating data view web parts with conditional formatting in SharePoint.

Here suppose we have a list that contains a calculated field as Status column. If we write the formula for the calculated column as below:

http://csharpcorner.mindcrackerinc.netdna-cdn.com/UploadFile/BlogImages/01062014040815AM/image2.jpg

Then, the list will appear as below:

http://csharpcorner.mindcrackerinc.netdna-cdn.com/UploadFile/BlogImages/01062014040815AM/image1.jpg

Suppose we have a list that contains a calculated column as progress Indicator and if we write the formula as below:

http://csharpcorner.mindcrackerinc.netdna-cdn.com/UploadFile/BlogImages/01062014040815AM/image4.jpg

Then, the list will appear as below:

http://csharpcorner.mindcrackerinc.netdna-cdn.com/UploadFile/BlogImages/01062014040815AM/image3.jpg

The technique used here is a combination of Calculated Columns and CSS/images styling on a list.