Hi, Emmana-
Your conditional formatting formula in A11 is
=AND(A11="",E11="")
Note that there is no consideration of a date, since from your
description it sounds like each sheet represents a single day.

Your conditional formatting formula in D11 is
=AND(D11="",E11="")

Your conditional formatting formula in E11 is
=AND(E11="",AND(A11="",D11=""))

You can copy those cells into the rest of your range.