I have a excel spreadsheet with the due date in field "D" and the status in field "e". I have successfully used conditional formatting to highlights due dates that are past due and have a status that is open RED using : =AND(E2<>"Done",E2<TODAY())

HOWEVER.... this also turns the cells that i have not yet entered in the task/duedate/status in red too. How do i make this ONLY look at cells that have text/date? I tried to use conditional formatting>format only cells that contain>no blanks and this did not work. please help!