Solved

How can I Apply Conditional Formatting to a SharePoint 2010 List

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

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

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

Question has a verified solution.

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

I wanted to share this with fellow Experts, who might not know. How often have you wanted to learn something, only to be set back by either restrictions imposed on "trial" or "evaluation" software?  How often have you had to rebuild a home networ…
Having trouble getting your hands on Dynamics 365 Field Service or Project Service trial? Worry No More!!!
Viewers will learn how to maximize accessibility options in an Excel workbook for users with accessibility issues.
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…
Suggested Courses

617 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