Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 862
  • Last Modified:

How can I Apply Conditional Formatting to a SharePoint 2010 List

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
Lord_Dragon
Asked:
Lord_Dragon
  • 3
  • 2
1 Solution
 
MontoyaProcess Improvement MgrCommented:
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
 
Lord_DragonAuthor Commented:
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
 
MontoyaProcess Improvement MgrCommented:
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
 
Lord_DragonAuthor Commented:
you are awesome! Thank you.
0
 
MontoyaProcess Improvement MgrCommented:
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

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now