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? :)