asked on

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

Montoya

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!

James Halliburton

ASKER

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?

Montoya

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

James Halliburton

ASKER

you are awesome! Thank you.

ASKER CERTIFIED SOLUTION

Montoya

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial