Please write a conditional formatting formula to do this:
If today's date is greater than due date (Column A value) then Fill the cell Red but not if
the value in column L is 'P' (check Mark - Windings 2)
This can easily be done by =A1<Today() ...then color A1 red
What I need added is that the cell should only be colored if there is no check mark in Column F . I guess an IF statement would do this.
Due Date (ColA) Completed(Col F)
1/15/2010 ..A1 should be red
1/15/2010 P ...A2 should not be red cause there is a check mark/P in column F