Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

How can I Apply Conditional Formatting to a SharePoint 2010 List

Posted on 2015-01-23
5
Medium Priority
?
772 Views
Last Modified: 2015-02-25
I am working in SharePoint 2010 and need a non-code solution:

I have a List in SharePoint with a column titled "Due Date".  I need the Due Date column to have multiple conditions placed upon it, they are...

any due dates less than today are colored Red

any due dates after today to 14 days out are colored Yellow

any due dates 15 days out and beyond are colored Green
0
Comment
Question by:Lord_Dragon
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
5 Comments
 
LVL 19

Expert Comment

by:Montoya
ID: 40566956
you need SharePoint Designer and do a dataview.

Here's a guide:  

https://support.office.com/en-us/article/Apply-conditional-formatting-to-a-Data-View-3263849d-4444-4f8c-80a9-680058e1bd52


If you happen to have bamboo tools, the datagrid view does that much faster!
0
 

Author Comment

by:Lord_Dragon
ID: 40575052
Usinig SharePoint designer, what would I enter as criteria or conditions to achieve the following?

I have a ciolumn titled "Due Date". I want the font for the items in this column to be colored Red, Yellow or Green depening upon their dates.

Due dates that are less than today should be red

Due dates from today to 14 days out would be Yellow

Due dates beyond 14 days out should be Green

can this be accomplished using SharePoint Designer 2010? if so how should the Conditions be set?
0
 
LVL 19

Expert Comment

by:Montoya
ID: 40575122
Yes, it can be done. I was ill, so apologies for the delay. I'll try to put together an example for you today.

Cheers,

Montoya
0
 

Author Comment

by:Lord_Dragon
ID: 40575636
you are awesome! Thank you.
0
 
LVL 19

Accepted Solution

by:
Montoya earned 2000 total points
ID: 40578188
work is killing me right now.. let me point in the right direction.

Create list:
(use task list.. it's easier, for this example)

Simple one first:
Go to SharePoint Designer, create a new web part page.
click INSERT / Data View
select the task list you just created.

it will display a grid of your list items.
Move your mouse over the left edge of one of the rows until you see a black arrow pointing to the right. 'CLICK!"
Now that row is selected.

Go to bottom right and choose:
     Conditional Formatting
     Create
     Apply Formatting

Now edit condition:
DueDate is greater than current date

now apply style:
Select background and change color to red.

Ok or Apply

Your rows that are past due should turn red.

Now, here's the problem that always exists in SharePoint.. calculated columns do NOT update automatically every day. This means that you can't really use a dynamic column to count down the number of days. You have to do workarounds in order to get true values for the current day. That takes some time.

Here are some links to help you:

http://blog.pentalogic.net/2008/11/truth-about-using-today-in-calculated-columns/

http://sharepoint.stackexchange.com/questions/45951/how-can-we-create-and-calculate-a-due-date-today-7-column-in-sp-2010

https://moonistahir.wordpress.com/category/sharepoint-2007/

I hope this helps.. just pressed against deadlines and I make it a habit not be late. :)
0

Featured Post

Get free NFR key for Veeam Availability Suite 9.5

Veeam is happy to provide a free NFR license (1 year, 2 sockets) to all certified IT Pros. The license allows for the non-production use of Veeam Availability Suite v9.5 in your home lab, without any feature limitations. It works for both VMware and Hyper-V environments

Question has a verified solution.

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

As with any other System Center product, the installation for the Authoring Tool can be quite a pain sometimes. This article serves to help you avoid making these mistakes and hopefully save you a ton of time on troubleshooting :)  Step 1: Make sur…
Ever visit a website where you spotted a really cool looking Font, yet couldn't figure out which font family it belonged to, or how to get a copy of it for your own use? This article explains the process of doing exactly that, as well as showing how…
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…
The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…

722 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