Conditional Formatting with Calculated Columns in SharePoint 2010


In this post we will discuss how we can do conditional formatting with calculated column in SharePoint 2010.

Read some SharePoint tutorials
SharePoint online: Ultimate tutorial guide PDF download


Get manager of current SharePoint user using SPServices and GetUserProfileByName



Cascading dropdownlist in SharePoint 2010 list using jQuery

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:
Conditional Formatting with Calculated Columns in SharePoint 2010
Conditional Formatting with Calculated Columns in SharePoint 2010
Then the list will appear like below:
Conditional Formatting with Calculated Columns in SharePoint 2010
Conditional Formatting with Calculated Columns in SharePoint 2010
Suppose we have a list that contains a calculated column as progress Indicator and if we write the formula like below:
Conditional Formatting with Calculated Columns in SharePoint 2010
Conditional Formatting with Calculated Columns in SharePoint 2010
Then the list will appear like below:
Conditional Formatting with Calculated Columns in SharePoint 2010
Conditional Formatting with Calculated Columns in SharePoint 2010
The technique used here is a combination of Calculated Columns and CSS/images styling on a list.
Check out Best Alternative to InfoPath -> Try Now

You May Also like the Following SharePoint Online Tutorials:

About Sagar Pardeshi

I am Developer working on Microsoft Technologies for the past 6+years. I am very much passionate about programming and my core skills are SharePoint, ASP.NET & C#,Jquery,Javascript,REST. I am running this blog to share my experience & learning with the community I am an MCP, MCTS .NET & Sharepoint 2010, MCPD Sharepoint 2010, and MCSD HTML 5,Sharepoint 2013 Core Solutions. I am currently working on Sharepoint 2010, MOSS 2007, Sharepoint 2013,Sharepoint 2013 App Dev, C#, ASP.NET, and SQL Server 2008.

View all posts by Sagar Pardeshi →