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.
Bookmarks