Solved

'Color' field in Lists - Sharepoint

Posted on 2011-02-14
13
856 Views
Last Modified: 2012-05-11
Hello,

I am trying to figure out how to add a colored field in a list for Sharepoint. What I mean for this is based on a certain status for a project, I want the field to be filled with a color, like Green for On Schedule, Yellow for Behind, and Red for Immediate Attention.

So, for example:
Project #1 - Location Philly - Status: [GREEN]
Project #2 - Location NY - Status: [RED]

Hopefully this is clear enough.

Thanks for your help everyone.
0
Comment
Question by:ITimaging
  • 5
  • 5
  • 2
  • +1
13 Comments
 
LVL 14

Expert Comment

by:KoenVosters
ID: 34892327
You can use jQuery to achieve this:
http://www.codegain.com/codesnippets/sharepoint/developmentprogramming/how-to-apply-color-coding-sharepoint-list-using-jquery.aspx

Add this code in a content editor webpart

If you don't know how to put jQuery on your SharePoint site:
http://weblogs.asp.net/jan/archive/2008/11/20/sharepoint-2007-and-jquery-1.aspx
0
 
LVL 4

Expert Comment

by:TEEDA
ID: 34893625
If you have access to SharePoint Designer, you can also do this using conditional formatting. If you need a "how to", let me know.
0
 
LVL 8

Expert Comment

by:zabiullah
ID: 34894152
In addition to the above references, you can also use calculated column with javascript/JQuery to achieve the same.

Here the references:

http://www.sharepointkings.com/2009/04/sharepoint-calculated-column-and-jquery.html
http://sharepointkb.wordpress.com/2009/04/14/customize-look-and-feel-with-calculated-columns/

Regards,
Zabi
0
Backup Your Microsoft Windows Server®

Backup all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

 

Author Comment

by:ITimaging
ID: 34896397
I don't really have access to the server to be able to deploy JQuery to the server, unfortunately, otherwise I'd use it. I do have Sharepoint Designer 2010 for it, though. TEEDA, do you happen to still have a "how-to" for that, please?
0
 
LVL 14

Expert Comment

by:KoenVosters
ID: 34896405
0
 

Author Comment

by:ITimaging
ID: 34897872
I'm having terrible luck with this thing. Okay, so I went through and got the formatting and everything set the one time, but after getting it setup it didn't actually do anything. It didn't change the background of anything in there. Now, I thought it was my mistake since it usually is so I thought I'd start over with it - didn't save the page and re-opened it so it was fresh. Now every time I actually try and open the data view, the list appears and then disappears. I can't click on any of the fields to actually apply a format.
0
 
LVL 4

Expert Comment

by:TEEDA
ID: 34897925
in your page, insert a web part zone if there isn't one there already and click Insert a dataview. Sort and filter as needed.  Select the chevron at the top right of the dataview and choose Conditional Formatting, which will open a task pane. Now select the table cell you want to color and click Create/Apply Formatting in the task pane. Create your condition and click OK. The Modify Style dialog appears, allowing you to set background color, fonts and so on. Good luck.
0
 
LVL 4

Expert Comment

by:TEEDA
ID: 34897958
is it possible that you chose Hide Content instead of Apply Formatting? I've done that once or twice.
0
 

Author Comment

by:ITimaging
ID: 34898041
Sorry, but I did try that TEEDA, as explained in Koen's link. Unfortunately it doesn't actually change the color. It does nothing to be precise.
0
 

Author Comment

by:ITimaging
ID: 34898047
I did check to see if I did, and I didn't. I made sure I made everything visible.
0
 
LVL 4

Expert Comment

by:TEEDA
ID: 34898155
If there are existing entries in your list that meet the conditions, then I'm mystified as to why the formatting isn't being applied.  But just in case, click the Set Visibility button in the task pane and click All Formatting Visible.
0
 

Author Comment

by:ITimaging
ID: 34898525
I'm baffled myself. I don't know why it's not filling it the proper colors, and I set it up so the condition is correct. I did set it for All Formatting Visible too. It's odd.
0
 
LVL 4

Accepted Solution

by:
TEEDA earned 500 total points
ID: 34898595
It sure is.  Data views can be finicky, so I'd start a brand new page and make sure your web part is within a web part zone and that it's the only web part on the page.  Good luck!
0

Featured Post

The Eight Noble Truths of Backup and Recovery

How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

The Scenario: Let’s say you have a quote worksheet in Excel that you use to work up sales figures and such for your clients. You utilize SharePoint to manage and keep track of these documents. You would like values from your worksheet to populate Sh…
I used to be SharePoint evangelist in our company, so my Outlook always full of questions about how to do this, or where I can find that. One day I found such an email with the following question: "how to attach 3-State workflow (one of the workflow…
This Micro Tutorial will teach you how to censor certain areas of your screen. The example in this video will show a little boy's face being blurred. This will be demonstrated using Adobe Premiere Pro CS6.
Along with being a a promotional video for my three-day Annielytics Dashboard Seminor, this Micro Tutorial is an intro to Google Analytics API data.

785 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question