I'm using the following formula in Conditional Formatting which will hightlight a cell red if the date is older than todays date and has a status which is not OVERDUE or CLOSED.

=AND(L7<>"Overdue",L7<>"Closed",G7<TODAY())

But if L7 and G7 are blank the formatting highlights the cells red. I'd like for this not to happen for rows yet to be completed.

Thanks in advance.