Highlight Row Color in SharePoint 2010 List items


There is a cool new feature in SharePoint 2010 which will let you to color the list rows based on specific criteria. SharePoint designer 2010 has this new feature and here is the steps to do it.

Here, I use default Tasks list for demo purpose.

1. Open SharePoint 2010 designer and open the site=>list=>view which you want to highlight.

2. Choose the View where you want to highlight the color. I choose “All Tasks” view.

image

 

3. In the “All Items.aspx” window in SharePoint 2010, click on the WebPart. It will activate other Ribbon Tabs to customize the view.

image

4. In “Option” tab, you can see an option “Conditional Formatting” where you can format Row & Column as you wish.

image

5. Once you chose “Format Row” option, it will show a dialog box where you can provide the condition and format information.

image

image

6. You can see the applied formatting in the designer itself. (I have taken this snapshot on 27th December 2010.)

image

7. List view will be shown like below.

image

Note : Whenever you make a change in the SharePoint designer, save the content and refresh the data to publish the modified view into SharePoint site.

Though this is a simple feature, hope you would enjoy it since no code needed to achieve this feature.

10 responses to this post.

  1. Many thanks.

    I was looking for the right solution and this was it.

    Reply

  2. Posted by Alicia on September 11, 2012 at 1:14 am

    This is FANTASTIC!!!!! There are posts all over the internet showing complex coding needed to accomplish this. You made my life SO easy!! Thanks.

    Reply

  3. Posted by vijayblog on October 13, 2012 at 11:07 am

    Thanks Lain and Alicia for your kind words!!!

    Reply

  4. Posted by Longbv on January 19, 2013 at 2:04 am

    Very good solution, is it apply to SP 2013 foundation?

    Reply

  5. Posted by Taylor on March 27, 2013 at 8:38 pm

    THANK YOU SO MUCH FOR POSTING THIS!! It was a life saver!! :)

    Reply

  6. Posted by Bill on April 18, 2013 at 11:52 pm

    While this works when you click on the list, the highlighting does not show when you insert the list as a webpart on a page. Do you know why that is and how to fix it?

    Reply

  7. Posted by Rosy on July 2, 2013 at 4:39 am

    I don’t see the options tab in my sharepoint designer. What could be the reason for this?

    Reply

  8. Posted by Tres on November 19, 2013 at 1:17 am

    Bill, I ran into the same thing. I suppose the reason why the modifications to the list view don’t apply to the Web part in a different page is that you’re just modifying that view’s default page (not the view itself per se, if that makes sense). But anyway, here is how you can apply the same formatting to a different Web page:

    While in SharePoint Designer (I am using 2010), click the Site Pages link in the left pane, or whatever directory holds the Web part page that you want to modify, possibly within All Files. Click the link for the page you want (for example Main.aspx), and then under the Customization group click “Edit file”.

    From there, you can follow the same steps 3-7 described in this article to select the Web part and use Conditional Formatting on the Ribbon to apply the style you want to the row or column. Save the page and refresh in your browser – kaboom!

    Good luck, and thanks again to vijayblog for putting together this very helpful write-up!

    Reply

  9. Thank you! This was short and sweet – just what I was looking for.

    Reply

  10. Posted by Johne401 on May 10, 2014 at 3:37 pm

    This design is incredible! You obviously know how to keep a reader amused. bfdeedkkdeae

    Reply

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

Follow

Get every new post delivered to your Inbox.

%d bloggers like this: