Solved

How can I Apply Conditional Formatting to a SharePoint 2010 List

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

Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

Question has a verified solution.

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

Many companies are making the switch from Microsoft to Google Apps (https://www.google.com/work/apps/business/). Use this article to learn more about what Google Apps has to offer and to help if you’re planning on migrating to Google Apps. It is …
User Beware!  This is a rather permanent solution to removing your email from an exchange server.  The only way to truly go back is to have your exchange administrator restore your mailbox from backups.  This is usually the option of last resort.  A…
Viewers will learn the different options available in the Backstage view in Excel 2013.
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…

910 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

Need Help in Real-Time?

Connect with top rated Experts

24 Experts available now in Live!

Get 1:1 Help Now