Conditional Formatting with Calculated Columns in SharePoint 2010

Posted: November 7, 2014 in SharePoint2010

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 like below:

Then the list will appear like below:

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

 Then the list will appear like below:
The technique used here is a combination of Calculated Columns and CSS/images styling on a list.
Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s