Solved

How can I Apply Conditional Formatting to a SharePoint 2010 List

Posted on 2015-01-23
5
612 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 500 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

Online Training Solution

Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action. Forget about retraining and skyrocket knowledge retention rates.

Question has a verified solution.

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

The System Center Operations Manager 2012, known as SCOM, is a part of the Microsoft system center product that provides the user with infrastructure monitoring and application performance monitoring. SCOM monitors:   Windows or UNIX/LinuxNetwo…
This collection of functions covers all the normal rounding methods of just about any numeric value.
The viewer will learn how to simulate a series of coin tosses with the rand() function and learn how to make these “tosses” depend on a predetermined probability. Flipping Coins in Excel: Enter =RAND() into cell A2: Recalculate the random variable…
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…

729 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