Here are my conditions:

1.)Turns cell orange =AND(E10<"",E$1<"",E10E$1)
2.)Turns cell to no fill =AND(E10<"",E$1<"",E10<E$1)
3.)Turns cell red =and("")

I need help on the third condition, =and("").

In E1 I have a week-ending date, in E10 I choose a date.

1.)Turns cell orange =AND(E10<"",E$1<"",E10E$1). If the date I enter in
E10 is after the week-ending date in E1, then the cell turns orange.
2.)Turns cell to no fill =AND(E10<"",E$1<"",E10<E$1). If the date I enter
in E10 is before or on the week-ending date in E1, then the cell does not
fill anything.

My third condition is what I need help on:

3.) If the week-ending date has not arrived, then do nothing, but if the
week-ending date has arrived and no date has been entered, then color the
cell red.

Thank you.