SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I am trying to format a Tasks list in SharePoint 2010 using Sharepoint Designer using the following settings under conditional formatting.

Field > Due Date = Less Than > Value = Current Date
Field > Status = Not Equal > Value = Completed
Click on Set Style > Change Text color to Red

When this is done some of the tasks that have dates in the future are showing in RED - this should only happen for dates that have past with tasks that are either 'In Progress', 'Waiting on someone else' or 'Not Started'.

Any ideas, anyone? :)

share|improve this question

Take a look at this:

The solution was for 2007 but it works fine in my 2010. Of course test this on your development server.

Basically: Create a view with: a calculated that spits out html (specified in a way to not conflict with sharepoint html) Place view on page. On page at footer add web part or alter page with designer (preferred in 2010 because the content editor web part actually breaks the links to choose different views.) have javascript that rerenders that html for browser viewing. Works very nice.

share|improve this answer

Using Designer,

  • open the Task list and then the View you want to format.
  • Put your mouse in a cell of the column or row you want to format.
  • Select "Conditional Formatting". Let me know if that helps -
share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.